Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “agin” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

220 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
agin5613271(None) 
again65218121again
aging77026351aging
agio57828451agio
agon56531881agon
ain37579101a_in
akin86328041akin
algin65718761algin
amin66042251amin
ayin76331741ayin
fagin9216571fagin
gain56042161gain
gin46055761_gin
acid77533402acid
acing87429152acing
acini75718982acini
actin74922552actin
adit56443662adit
aegis6316782aegis
aeon45634612aeon
ag311067462ag__
aga410447232ag_a
agar58726412agar
agas55938842agas
age47154332ag_e
aged67334252aged
agee56241492agee
ageing84213402ageing
agene65621582agene
agent65829642agent
ager55935842ager
ages55844592ages
aggie73415012aggie
agha87417302agha
agile65122262agile
agings86312672agings
agios65919862agios
agism84614062agism
agist66325582agist
agita6315422agita
agly86821802agly
agma77623272agma
ago48845522ag_o
agog68019002agog
agone65924552agone
agons66423782agons
agony96415652agony
agria65517142agria
ags47551662ag_s
ague55725922ague
ahi68040232ahi_
ahing98928352ahing
ahis76135382ahis
ai211288402a_i_
aid49269092a_id
ail37171052a_il
aim57858222a_im
ains46158892a_ins
air38058402a_ir
airn46433842airn
ais39083582a_is
ait38093912a_it
alan46844082alan
algid75415582algid
algins74816432algins
alien56425582alien
alif76242142alif
align65016502align
aline57243152aline
alit46155692alit
aloin55227422aloin
amain74922912amain
amen66733152amen
ami56646812ami_
amia66836902amia
amid77036362amid
amie66339852amie
amine75835382amine
amino75425502amino
amins75534322amins
amir65129752amir
amis66445322amis
an211879082a__n
angina7413132angina
ani37751182ani_
anil46437432anil
anion55028812anion
anis45746472anis
anon46134852anon
apian75018332apian
aping87327232aping
argil65116882argil
argon65520592argon
aria46245432aria
arid57642722arid
aril45843022aril
auxin121411912auxin
avian84616052avian
avid88325972avid
avion84218342avion
awing96827322awing
awn68035912a_wn
axil116424452axil
axing138521372axing
axion1211316912axion
axis116127912axis
axon115524302axon
ayins85321612ayins
azan136521782azan
azine146721412azine
azon135725052azon
basin75026922basin
begin85117352begin
bin56658652_bin
blin67228172blin
brin67038192brin
cabin94820942cabin
caging105321022caging
cain65643912cain
chin96934742chin
coin66645352coin
din46459472_din
djin12911632djin
egis56520652egis
fagins10513862fagins
fain75840562fain
fin66458042_fin
foin77231562foin
gaen57329602gaen
gaging94718402gaging
gains65729512gains
gait56150192gait
gamin84423002gamin
gan48060132_gan
gaun56427712gaun
gen45950512_gen
gib66443542_gib
gid57047282_gid
gie47149552_gie
gien56330032_gien
gig56040762_gig
gink97129532_gink
gins55543962_gins
gip67645372_gip
girn56026872_girn
git46266062_git
grin55733722grin
gun47240802_gun
hin67559572_hin
in28150872__in
jin106443942_jin
join116724832join
kain85334302kain
kin76353982_kin
lagan66520342lagan
lain46146282lain
lapin75222922lapin
layin84720332layin
lin37967382_lin
login66025002login
loin46838722loin
magi76329532magi_
magian9312832magian
magic105818662magic
main65345522main
margin94016852margin
matin75132852matin
mavin105722952mavin
pagan86121162pagan
paging104020402paging
pain65647242pain
patin76832852patin
pavin105623202pavin
pein65834942pein
pin57066732_pin
pyin96823232pyin
quin135823922quin
ragi56032282ragi_
raging85126432raging
ragis66325602ragis
rain46251732rain
ravin85624652ravin
rawin85521472rawin
reagin74915532reagin
rein46040892rein
rin36663192_rin
ruin47430512ruin
sabin74924952sabin
sain45551292sain
sarin55239252sarin
sasin54626572sasin
satin55935222satin
savin84625082savin
shin75634312shin
sign55523062sign
sin36265902_sin
skin85927542skin
spin66231302spin
tain45548072tain
takin94921302takin
thin76732392thin
tin36362182_tin
twin76023082twin
tyin76424002tyin
vagi86719362vagi_
vagina102710932vagina
vain75233002vain
vein75625752vein
waging114318382waging
wagon94312952wagon
wain75840202wain
whin105225692whin
win66456302_win
yagi86922242yagi_
yagis95416572yagis
yin67648742_yin
yogin98317742yogin
zayin174512042zayin
zein135620602zein
zin125643782_zin

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691298720.376475242.0
2DLD Change Limit298722201.03029001.9
3Display Results2202200.0633492.1
 (SQL Overall)1786912201.469121641.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.