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

242 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
inns4692093(None) 
inks86926501inks
inn36727431inn_
ins35945601i_ns
ions46737851ions
jinns126013841jinns
linns56123331linns
ains46158882ains
airns55521032airns
anas46649862anas
ands57833612ands
anes45255932anes
anis45746462anis
anna45529012anna
annas55824882annas
ants47243472ants
anus47131112anus
awns75324432awns
banns75321232banns
bans66555132bans
bens65945702bens
binds86627472binds
bines76946792bines
bins66548252bins
bints76130182bints
bunns74718292bunns
buns66243722buns
cans65050842cans
cines75239682cines
cions75222852cions
conns75024232conns
cons66057692cons
dans56748142dans
dens55945072dens
dines66449152dines
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652042dins
dints67431312dints
djinns1443132djinns
dons56048702dons
duns55140432duns
ends56528522ends
engs56121392engs
ens37245922_ens
eons46638712eons
erns45428222erns
fans76247362fans
fens76139762fens
finds95424822finds
fines86644262fines
finis86824262finis
finks125424222finks
finny114716752finny
finos86226952finos
fins75849092fins
firns86018542firns
fons76943892fons
funs75235732funs
gens55740072gens
ginks104319562ginks
ginny95314572ginny
gins55543952gins
girns64516802girns
gnus56518002gnus
guns55533482guns
hens75642572hens
hinds96721472hinds
hinny115616672hinny
hins76447992hins
hints87330622hints
hons77350782hons
huns76136932huns
ibis66519582ibis
ices66129642ices
ichs96214712ichs
icons76516492icons
ides57734232ides
ids47535462i_ds
ifs67124242i_fs
iggs66612672iggs
ikons96311012ikons
ilks87218572ilks
ills47030422ills
imps86221122imps
in28150862i_n_
inane52820342inane
inanes62519802inanes
inby95315662inby
inch95420822inch
incus73315052incus
info75617352info
infos84311672infos
inia45024702inia
inions64417002inions
ink76433632i_nk
inky115321582inky
inly75622212inly
inned64118422inned
inner54920632inner
inners63919352inners
inro45920792inro
inruns6359512inruns
inti46626082inti
intis55121642intis
into45026152into
inurns63310982inurns
ion36051022ion_
ires45639282ires
iris45732552iris
irks86220132irks
irons55324132irons
is27048212i__s
isms66213472isms
its35538832i_ts
iwis77117012iwis
jinks165019332jinks
jinn115420242jinn_
jinni125310632jinni
jinnis13489052jinnis
jins115635012jins
kens85435232kens
kilns95112982kilns
kinas95626912kinas
kinds106221812kinds
kines95039132kines
kings105825562kings
kinins104014582kinins
kinks84926082kinks
kinos96626142kinos
kins85747902kins
kirns95315452kirns
lens46146492lens
liens56525502liens
limns75718392limns
linens64818392linens
lines57054572lines
lings67135772lings
linins65922142linins
links96430192links
linn46034592linn_
linos55631502linos
lins47059052lins
lints57137192lints
lions55923212lions
mans66354532mans
miens76118302miens
minas75434112minas
minds85427122minds
mines75651952mines
minis75432992minis
minks115829272minks
minny104518662minny
mints76834042mints
minus75223932minus
mons68152252mons
muns65535912muns
nans46139392nans
nibs65028312nibs
nils46132452nils
nims66226882nims
nine45842172nine
nines55937342nines
ninny84514932ninny
ninons64913772ninons
nips65830922nips
nits45741642nits
nos38859322_nos
nuns45228232nuns
nus37939392_nus
oinks94819912oinks
ones46146532ones
onos46229002onos
ons36148512_ons
onus45826812onus
owns76819582owns
pans65855722pans
pens65649642pens
pians75126962pians
pinas75434452pinas
pines76048862pines
pings85830882pings
pinks115729382pinks
pinna75320182pinna
pinnas85315512pinnas
pinny105222062pinny
pinons86019942pinons
pins65558452pins
pints75936222pints
pions75826392pions
pirns76020092pirns
pons65850602pons
puns66641482puns
rinds64826142rinds
rings65029172rings
rinks94827102rinks
rins46153192rins
runs46438072runs
sans45153352sans
signs65516322signs
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272sins
sinus55523852sinus
sons46049552sons
sunns55017352sunns
suns45841902suns
tans46154812tans
tens45647412tens
tines54848422tines
tings65329192tings
tinny85317652tinny
tins45251302tins
tints56030922tints
tons46553052tons
tuns45138662tuns
uns35936752_uns
urns46323892urns
vans76236722vans
vinas85126342vinas
vines85137642vines
vinos84723072vinos
wans76452262wans
wens76337932wens
winds95425602winds
wines85546862wines
wings95727242wings
winks125325432winks
winos84625042winos
wins75949172wins
wons74942042wons
wynns11517472wynns
wyns105717032wyns
yens75832262yens
yins75335122yins
zincs165312932zincs
zines145232652zines
zings154620892zings
zins135735002zins

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.0602978183.3
2DLD Change Limit298722420.95631246.9
3Display Results2422420.0435627.9
 (SQL Overall)1786912421.059168735.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.