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 “inlander” with Change Limit: [1] [2] [3]

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

144 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
inlander93722(None) 
inlanders1036141inlanders
islander946101islander
bilander1136672bilander
blander103715162_blander
colander1139032colander
inaner62213542in_an_er
inland7310312inland__
inlands838782inland_s
inlayer1036932inla_yer
insaner7310442insan_er
intender93310442intender
invader11146452inva_der
islanded1035512islanded
islanders1035282islanders
lander74028482__lander
mainlander1352972mainlander
slander84015442_slander
solander948122solander
uitlander1042962uitlander
uplander1145532uplander
auslander1043883auslander
balancer1246603balancer
bander93928223__bander
bilanders1235963bilanders
bladder11429153_bladder
blader93618583_bla_der
blanker134612023_blanker
blender104613843_blender
blinder103912983_blinder
blonder104011943_blonder
blunder103813153_blunder
brander103915823_brander
calender1138273calender
clanger104113493_clanger
colanders1238013colanders
cylinder1433383cylinder
dander811222993__dander
demander12238723demander
endanger1045853endanger
engender1046633engender
enhancer1346683enhancer
enlarger944153enlarger
expander18145803expander
flanger113412623_flanger
flanker143911293_flanker
flinder11319873_flinder
gander84322763__gander
gladder10398313_gladder
glancer103710073_glancer
glanders103811503_glanders
glandes95413833_glandes
grander93315873_grander
hander104526433__hander
highlander1852563highlander
implanter1385363implanter
inane52820343in_an_e_
inanes62519803in_an_es
incanted11259543incanted
incenter102212093incenter
incliner1038513inclin_er
indenter92311443indenter
infante101910883infante_
infantes11249633infantes
inflamer1356123infla_mer
inflater1149893infla_ter
infolder1256433infolder
ingather1244783ingather
inhaler1068053inha_ler
inhauler1163943inhauler
inholder1276113inholder
inlace82513043inla_ce_
inlaced10239873inla_ced
inlaces92512903inla_ces
inlaid7310143inlaid__
inlayers1135643inla_yers
inlier63615363inl__ier
inner54920633in__n_er
insane6314893insan_e_
insider849733in_sider
insnarer865303insnarer
instanter946243instanter
intended102310413intended
intenders10219373intenders
intenser8199443intenser
intoner7811673inton_er
intruder945213intruder
invade10157853inva_de_
invaded12127043inva_ded
invaders12105303inva_ders
invades11118293inva_des
inventer112410843inventer
island738533island__
islands837323island_s
kneader1275893knea_der
ladder84617623__ladder
lader65633723__la_der
lancer84319973__lancer
landed84619243__landed
landers84026213__landers
landler84113203__landler
lanker104123003__lanker
lanner64920603__lanner
larder73720973__larder
lauder73815013__lauder
launder8309143__launder
lender73921273__lender
lowlander1342993lowlander
mainlanders1462503mainlanders
malanders1237023malanders
meander1049973_meander
oleander936403oleander
outlander1045733outlander
pander93725523__pander
philander1544063philander
planer84122653_plan_er
planner93511623_planner
planter94017803_planter
plunder103810503_plunder
pomander1347083pomander
relanded102410463relanded
relaunder1053703relaunder
sander74828533__sander
slanders94014013_slanders
slender83413593_slender
solanders1036963solanders
squander1835533squander
stander84316163_stander
strander97112063strander
uitlanders1142833uitlanders
unbanded123010563unbanded
unhanded132910183unhanded
unhandier1344883unhandier
unkinder1335363unkinder
unlade72714153unla_de_
unladed92614373unla_ded
unladen8248653unla_den
unlades82612833unla_des
unloader936643unloader
unwinder1235613unwinder
uplanders1234853uplanders
wander104423713__wander
zander163417113__zander
zinfandel2251543zinfandel

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621447.93618417.6
3Display Results1441440.0632285.7
 (SQL Overall)1786911448.42221217.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.