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

194 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
indoor73840(None) 
indoors838551indoors
door56928512__door
indol63714872ind_ol
indole74516052indole
indols74714202indols
indorsor953202indorsor
indow95011662ind_ow
indows104210792indows
inpour837062inpour
pandoor10358582pandoor
tandoor8278562tandoor
undoer73113042undoer
unmoor836312unmoor
anchor113911973anchor
andro6314163andro_
andros7313303andros
ardor64617863ard_or
ardour74110903ardour
binder94422873bind_er
boor66130683__boor
candor94516423cand_or
candour104210243candour
cinder94119123cind_er
condor94616973cond_or
doer57734703__doer
dolor67617963__dolor
donor64418193__donor
doom76430073__doom
doors65022133__doors
dor47253923__d_or
dorr56627723__dorr
dour56330433__dour
enamor838753enamor
endear74110013endear
ender64325863end_er
endopod1145763endopod
endorsor943723endorsor
endow94510983end_ow
endower1138483endower
endows104610423endows
enduro7338623enduro
enroot6615993enroot
finder104020233find_er
finfoot1347173finfoot
floor84215233_floor
hinder104120063hind_er
ichor1039483i_chor
idiom899963i_diom
idiot6718863i_diot
idler65015663i_dler
idol56818633i_d_ol
idols65514133i_dols
igloo6410493igloo_
igloos738033igloos
ignitor8125263ignitor
inaner62213543inaner
inboard1037063inboard
inborn8319143inborn
incher114114033incher
incisor955323incisor
incog838253in_cog
incogs937903incogs
income10712093income
incomer1169943incomer
incony1139083incony
incur72212253in_cur
indaba935633indaba
indeed83913563indeed
indene73215373indene
indent73021243indent
indentor9288513indentor
index13310983ind_ex
indexer15287253indexer
indict93115573indict
indictor1147463indictor
indie63721473ind_ie
indies73822783indies
indign8308473indign
indigo8388023indigo
indigos9347823indigos
indite73520323indite
inditer83514233inditer
indium939503indium
indoles83716363indoles
indorse8108193indorse
indorser985713indorser
indorsors1043683indorsors
indowed1237443indowed
indoxyl1842423indoxyl
indri6310793ind_ri
indris7311963indris
induce93811533induce
inducer10318763inducer
induct93212743induct
inductor1146333inductor
indue63516673ind_ue
indued83411653indued
indues73515263indues
indult73614033indult
infer84215033in_fer
inflow1235293inflow
info75617353in_fo_
infold10128163infold
inform11310153inform
infos84311673in_fos
ingot61221063in_got
ingots7912063ingots
inion54620183in_ion
inions64417003inions
inker94421093in_ker
inkhorn1444363inkhorn
inkier104013783inkier
inkpot1237813inkpot
inkwood1584533inkwood
inlier63615363inlier
inmost8411363inmost
inner54920633in_ner
inpours936423inpours
inro45920793in_ro_
inroad737933inroad
inshore1038723inshore
insofar1043543insofar
insole63515863insole
insoul638463insoul
instar6310013instar
inter55028493in_ter
into45026153in_to_
intomb1036403intomb
intone61115433intone
intoner7811673intoner
intort6418923intort
intown936153intown
intro54915853intro_
intron64215023intron
intros64215773intros
invar839513in_var
invoke1336213invoke
invoker1435363invoker
inwove12167273inwove
iodoform1442793iodoform
iodophor1453063iodophor
iodous7311503iodous
kinder113716843kind_er
kindler12309983kindler
midnoon1044683midnoon
minder94822503mind_er
minor74920063min__or
misdoer1048633misdoer
moor66628553__moor
noir46722433_n_oir
nonpoor956483nonpoor
noo37154043_n_oo_
nook85728493_n_ook
noon47134623_n_oon
nor38048823_n__or
odor55718093_od_or
odour64710493_odour
outdoor836713outdoor
pandoors11258983pandoors
pandour10408213pandour
pinder94523453pind_er
poor65630223__poor
qindar16317173qind_ar
santoor737433santoor
snood64616163sn_ood
snook95115573sn_ook
snool55118643sn_ool
snoop75317173sn_oop
snoot55030143sn_oot
spoor75016353_spoor
sudor6312623sud_or
tandoori9244773tandoori
tandoors9258053tandoors
tinder73821803tind_er
uncool8610113uncool
under64624213und_er
undo55620153und_o_
undock1337703undock
undoers82910583undoers
undoes73917403undoes
undone7914253undone
unhood1039233unhood
unhook1347523unhook
unmoors945903unmoors
unroof9410193unroof
unroot6315553unroot
vendor10359803vend_or
winder104025263wind_er
windier113412163windier
window1347363wind_ow
windows1447743windows
windowy1744643windowy
windrow1445853windrow

Search took 10 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 Filter1786911127160.406440125.6
2DLD Change Limit1127161948.57613143.2
3Display Results1941940.0633079.4
 (SQL Overall)1786911949.04519755.8
 
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.