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 “inn” 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.

268 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
inn3672744(None) 
in28150871i_n
ink76433641ink
inns46920931inns
ins35945611ins
ion36051031ion
jinn115420251jinn
linn46034601linn
ain37579102ain
ains46158892ains
airn46433842airn
an211879082_an
ana39559832ana
and47244182and
ane37866952ane
ani37751182ani
anna45529012anna
anon46134852anon
ant37270792ant
any68440492any
awn68035912awn
ban58366842ban
ben56554922ben
bin56658652bin
bind76234522bind
bine66650872bine
bins66548262bins
bint67355052bint
bun56348142bun
bunn65023652bunn
can57760142can
cine66242952cine
cion613330922cion
con510268022con
conn66229132conn
dan46859672dan
den47554342den
din46459472din
dine55555342dine
ding66940962ding
dink97137812dink
dino56036762dino
dins56652052dins
dint56759062dint
djinn1355632djinn
don46757652don
dun46545582dun
en28052392_en
end46834362end
eng46726782eng
ens37245922ens
eon36052082eon
ern35738362ern
fan67158862fan
fen66851352fen
fin66458042fin
find87532612find
fine75147962fine
fink117532132fink
finny114716752finny
fino76034702fino
fins75849102fins
firn76927512firn
fon66352272fon
fun66841142fun
gan48060132gan
gen45950512gen
gien56330032gien
gin46055762gin
gink97129532gink
ginny95314572ginny
gins55543962gins
girn56026872girn
gnu45522042gnu
gun47240802gun
hen67555272hen
hin67559572hin
hind85529762hind
hinny115616672hinny
hins76448002hins
hint77455752hint
hisn79620942hisn
hon67759382hon
hun65844712hun
ice56737252ice
ich86227752ich
ick97329332ick
icon66922042icon
icy86322132icy
id38941852i_d
ids47535482ids
if57239962i_f
iff96730402iff
ifs67124252ifs
igg57116802igg
ikon85814962ikon
ilk78325312ilk
ill37437102ill
imp76626982imp
inane52820342inane
inby95315662inby
inch95420822inch
info75617352info
inia45024702inia
inion54620182inion
inks86926502inks
inky115321582inky
inly75622212inly
inned64118422inned
inner54920632inner
inro45920792inro
inrun52911372inrun
inti46626082inti
into45026152into
inurn53712862inurn
ions46737852ions
ire36943182ire
irk76426372irk
iron46728462iron
is27048222i_s
ism56322392ism
it28455692i_t
its35538842its
ivy96317452ivy
jin106443942jin
jink156227212jink
jinni125310632jinni
jinns126013842jinns
jins115635022jins
jinx185516582jinx
jun105932062jun
ken76343992ken
kiln85620992kiln
kin76353982kin
kina85632012kina
kind96128572kind
kine85643442kine
king95933672king
kinin94917332kinin
kink76034412kink
kino86233632kino
kins85747922kins
kirn87123452kirn
lien45339812lien
limn66527702limn
lin37967382lin
line46965582line
linen55728722linen
ling57447972ling
linin58025522linin
link86943452link
linns56123332linns
lino46343382lino
lins47059062lins
lint416266242lint
liny78141332liny
lion46334452lion
man57465872man
men59252852men
mien65028372mien
mina65136932mina
mind75434392mind
mine67256182mine
mini65634572mini
mink106636542mink
minny104518662minny
mint66758072mint
minx137723362minx
mon57561582mon
mun56143862mun
na28652482_na
nan37854882nan
ne27045102_ne
nib56745202nib
nil36144202nil
nim57142962nim
nine45842182nine
ninny84514932ninny
ninon55517382ninon
nip56945992nip
nit37065952nit
nix106932842nix
no29353242_no
nu26331952_nu
nun35537742nun
oink85429352oink
on28057182_on
one37050912one
ono36838032ono
ons36148512ons
own66429702own
pan58466452pan
pen56558842pen
pian66136102pian
pin57066732pin
pina65842642pina
pine67755722pine
ping75943602ping
pink107039392pink
pinna75320182pinna
pinny105222062pinny
pinon76024532pinon
pins65558462pins
pint66963182pint
piny911838362piny
pion67235302pion
pirn67128382pirn
pun58846512pun
ran38266622ran
rin36663192rin
rind56535612rind
ring56541162ring
rink87737002rink
rins46153202rins
run36244992run
sen36058522sen
sign55523062sign
sin36265902sin
sine46560632sine
sing57544182sing
sinh76238052sinh
sink86640152sink
sins46755282sins
son37761952son
sun37149032sun
sunn45423592sunn
syn67024122syn
tan37167582tan
ten35856112ten
tin36362182tin
tine45855142tine
ting56139922ting
tinny85317652tinny
tins45251312tins
tint46758872tint
tiny76134642tiny
ton310265102ton
tun35845192tun
un28341142_un
uns35936762uns
urn35731472urn
van66246332van
vina76331812vina
vine75643692vine
vino76128442vino
viny106025962viny
wan66761942wan
wen66249602wen
win66456302win
wind85533862wind
wine74953432wine
wing86339232wing
wink116435032wink
wino75933622wino
wins75949182wins
winy107034332winy
won66252062won
wyn95921442wyn
wynn105811292wynn
yen66847382yen
yin67648742yin
yins75335132yins
yon67348952yon
zin125643782zin
zinc156819102zinc
zine137036162zine
zing145728622zing
zins135735012zins

Search took 1 second 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 Filter178691140840.266671770.7
2DLD Change Limit140842680.37337758.7
3Display Results2682680.0465826.1
 (SQL Overall)1786912680.685260862.8
 
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.