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
inn3672743(None) 
in28150861i_n
ink76433631ink
inns46920931inns
ins35945601ins
ion36051021ion
jinn115420241jinn
linn46034591linn
ain37579092ain
ains46158882ains
airn46433832airn
an211879082_an
ana39559832ana
and47244172and
ane37866952ane
ani37751182ani
anna45529012anna
anon46134852anon
ant37270792ant
any68440492any
awn68035912awn
ban58366842ban
ben56554922ben
bin56658642bin
bind76234512bind
bine66650862bine
bins66548252bins
bint67355042bint
bun56348142bun
bunn65023652bunn
can57760142can
cine66242942cine
cion613330912cion
con510268022con
conn66229132conn
dan46859672dan
den47554342den
din46459462din
dine55555332dine
ding66940952ding
dink97137802dink
dino56036752dino
dins56652042dins
dint56759052dint
djinn1355632djinn
don46757652don
dun46545582dun
en28052392_en
end46834352end
eng46726782eng
ens37245922ens
eon36052082eon
ern35738362ern
fan67158862fan
fen66851352fen
fin66458032fin
find87532602find
fine75147952fine
fink117532122fink
finny114716752finny
fino76034692fino
fins75849092fins
firn76927502firn
fon66352272fon
fun66841142fun
gan48060132gan
gen45950512gen
gien56330022gien
gin46055752gin
gink97129522gink
ginny95314572ginny
gins55543952gins
girn56026862girn
gnu45522042gnu
gun47240802gun
hen67555272hen
hin67559562hin
hind85529752hind
hinny115616672hinny
hins76447992hins
hint77455742hint
hisn79620932hisn
hon67759382hon
hun65844712hun
ice56737242ice
ich86227742ich
ick97329322ick
icon66922042icon
icy86322122icy
id38941842i_d
ids47535472ids
if57239952i_f
iff96730392iff
ifs67124242ifs
igg57116792igg
ikon85814952ikon
ilk78325302ilk
ill37437092ill
imp76626972imp
inane52820342inane
inby95315662inby
inch95420822inch
info75617352info
inia45024702inia
inion54620182inion
inks86926502inks
inky115321582inky
inly75622212inly
inned64118422inned
inner54920632inner
inro45920792inro
inrun52911372inrun
inti46626082inti
into45026152into
inurn53712862inurn
ions46737852ions
ire36943172ire
irk76426362irk
iron46728462iron
is27048212i_s
ism56322382ism
it28455682i_t
its35538832its
ivy96317442ivy
jin106443932jin
jink156227202jink
jinni125310632jinni
jinns126013842jinns
jins115635012jins
jinx185516572jinx
jun105932062jun
ken76343982ken
kiln85620982kiln
kin76353972kin
kina85632002kina
kind96128562kind
kine85643432kine
king95933662king
kinin94917322kinin
kink76034402kink
kino86233622kino
kins85747912kins
kirn87123442kirn
lien45339802lien
limn66527692limn
lin37967372lin
line46965572line
linen55728722linen
ling57447962ling
linin58025522linin
link86943442link
linns56123332linns
lino46343372lino
lins47059052lins
lint416266232lint
liny78141322liny
lion46334442lion
man57465872man
men59252852men
mien65028362mien
mina65136922mina
mind75434382mind
mine67256172mine
mini65634562mini
mink106636532mink
minny104518662minny
mint66758062mint
minx137723352minx
mon57561582mon
mun56143862mun
na28652482_na
nan37854882nan
ne27045102_ne
nib56745192nib
nil36144192nil
nim57142952nim
nine45842172nine
ninny84514932ninny
ninon55517382ninon
nip56945982nip
nit37065942nit
nix106932832nix
no29353242_no
nu26331952_nu
nun35537742nun
oink85429342oink
on28057182_on
one37050912one
ono36838032ono
ons36148512ons
own66429702own
pan58466452pan
pen56558842pen
pian66136092pian
pin57066722pin
pina65842632pina
pine67755712pine
ping75943592ping
pink107039382pink
pinna75320182pinna
pinny105222062pinny
pinon76024532pinon
pins65558452pins
pint66963172pint
piny911838352piny
pion67235292pion
pirn67128372pirn
pun58846512pun
ran38266622ran
rin36663182rin
rind56535602rind
ring56541152ring
rink87736992rink
rins46153192rins
run36244992run
sen36058522sen
sign55523052sign
sin36265892sin
sine46560622sine
sing57544172sing
sinh76238042sinh
sink86640142sink
sins46755272sins
son37761952son
sun37149032sun
sunn45423592sunn
syn67024122syn
tan37167572tan
ten35856112ten
tin36362172tin
tine45855132tine
ting56139902ting
tinny85317652tinny
tins45251302tins
tint46758862tint
tiny76134632tiny
ton310265102ton
tun35845192tun
un28341142_un
uns35936762uns
urn35731472urn
van66246332van
vina76331802vina
vine75643682vine
vino76128432vino
viny106025952viny
wan66761942wan
wen66249602wen
win66456292win
wind85533852wind
wine74953422wine
wing86339222wing
wink116435022wink
wino75933612wino
wins75949172wins
winy107034322winy
won66252062won
wyn95921442wyn
wynn105811292wynn
yen66847382yen
yin67648732yin
yins75335122yins
yon67348952yon
zin125643772zin
zinc156819092zinc
zine137036152zine
zing145728612zing
zins135735002zins

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.283631417.0
2DLD Change Limit140842680.45331090.5
3Display Results2682680.0604466.7
 (SQL Overall)1786912680.796224486.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.