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

228 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
dhoora103565(None) 
dhooras1135941dhooras
dhooly13457142dhooly
dhooti1035662dhooti
dhourra1152022dhourra
dobra85013102d_obra
door56928512d_oor_
doors65022132d_oors
doura66518662d_oura
hooka125513902_hooka
hoorah124411112_hoorah
hooray123011372_hooray
hora76136562_h_ora
rhodora1144292rhodora
agora6914333_agora
angora71111573angora
aurora6411763aurora
bhoot104322103bhoo_t
bhoots11459913bhoots
boor66130683_boor_
boors74325013_boors
bora66141633__bora
chakra15437533chakra
chloral12169983chloral
choana1138443choana
choir105313603choir_
choirs114911883choirs
chola104718033ch_ola
cholera12409093cholera
cholla113911023cholla
chook146015043choo_k
chooks155312793chooks
choose115116143choose
choosy14459103choosy
choral115118493ch_oral
chord115917263ch_ord
chore105126763ch_ore
chorea115216083chorea
chroma132912473chroma
cobra95214403_cobra
cohort1110720263cohort
copra98115463_copra
dagoba1074943dagoba
dahoon1039053dahoo_n
dahoons1137753dahoons
datura738023datura
decor84717573decor_
decors94017773decors
deform1259623deform
dehorn10439653dehorn
dehort104618103dehort
deodar837713deodar
deodara945243deodara
deport94922393deport
desorb95210203desorb
deworm1249533deworm
dharma1276103dharma
dharna1055263dharna
dhobi1136973dh_obi
dhobis1236113dhobis
dhole95215363dh_ole
dholes104914793dholes
dhootie1136473dhootie
dhootis1135683dhootis
dhoti9310123dh_oti
dhotis1038973dhotis
dhourras1252233dhourras
dhow116614003dh_o_w
dhows125911223dh_ows
dhurna1043563dhurna
dobla84913643d_obla
dobras94811913d_obras
dobro84412213d_obro
doer57734703d_oer_
doers65225713d_oers
dogma96112463d_ogma
dolma86214173d_olma
dolor67617963dolor_
dolors75115313dolors
dona55529633d__ona
donga76718423d_onga
donna66215033d_onna
donor64418193donor_
donors75115793donors
doodad936423d_oodad
doody105517913d_oody
dooly94821803d_ooly
doom76430073d_oo_m
dooms85321343d_ooms
doomy116018263d_oomy
doorman1037063d_oorman
doormat1059073d_oormat
doorway1444243d_oorway
doozy186813713d_oozy
dopa77220903d__opa
dor47253923d__or_
dore56353303d__ore
dork96531463d__ork
dorm76834633d__orm
dorp76028053d__orp
dorr56627723d__orr
dorrs65520593d_orrs
dors56747603d__ors
dorsa64617283d_orsa
dory85836233d__ory
doula65717773d_oula
douma85817703d_ouma
dour56330433d_our_
dourah10479813d_ourah
douras75016723d_ouras
dowry126312483d_owry
drool65416103droo_l
drools74412813drools
drooly104911073drooly
droop85814823droo_p
droops95110963droops
droopy12458243droopy
drosera836203drosera
dura55232113d__ura
durra65315793d_urra
fedora1038593fedora
femora1149583femora
floor84215233floor_
floors94112353floors
flora85317103_flora
fora75937393__fora
gooral7310463_gooral
hijra1535643_hijra
hoar76729163_hoar_
hoard94918313_hoard
hoars85925553_hoars
hoary114516763_hoary
hoer76533983_hoer_
hoers85724923_hoers
holla84918493_holla
honda9414983_honda
honor85718623_honor_
honors94816793_honors
hooch135813703_hooch
hood85132333_hoo_d
hoods95124083_hoods
hoody124919723_hoody
hooey114926603_hooey
hoof106036583_hoo_f
hoofs115721043_hoofs
hook116133283_hoo_k
hookah16488243_hookah
hookas135312493_hookas
hooks125027123_hooks
hooky155220263_hooky
hooly115022223_hooly
hoop96129983_hoo_p
hoopla1147633_hoopla
hoops105621073_hoops
hoorahs13399603_hoorahs
hoorays13418373_hoorays
hoot75752103_hoo_t
hoots84830253_hoots
hooty115022443_hooty
horah117922053_h_orah
horal86328683_h_oral
horas86333103_h_oras
horn76735613_h_orn
hosta85917833_hosta
hour75827313_hour_
houri85915253_houri
hours85422393_hours
hoya107418373_h_oya
hydra12249223_hydra
ixora1236913_ixora
kora86431553__kora
loofa85912813_loofa
moira71012023_moira
moola75117033_moola
moor66628553_moor_
moors74923143_moors
moory105115793_moory
mora66641273__mora
okra86413573__okra
ora37250833___ora
orra46120723__orra
pakora1247283pakora
phobia13278603phobia
phooey14379233phooey
poor65630223_poor_
poori74816233_poori
remora8414593remora
rhodoras1244453rhodoras
senora63216163senora
shoer84722163shoer_
shoers94518333shoers
shofar1236313shofar
shoo75929893shoo__
shooed103916083shooed
shook124920163shoo_k
shooks134515633shooks
shool84523153shoo_l
shools94919013shools
shoon84022013shoo_n
shoos84226363shoo_s
shoot84235913shoo_t
shoots94619363shoots
shoran94016043sh_oran
shore85432653sh_ore
shorl84720253sh_orl
shorn85722183sh_orn
short85040533sh_ort
sora45746913__sora
spoor75016353spoor_
spoors84014033spoors
theory121098363theory
thorax1638253th_orax
thoria93012893thoria
thorn85318703th_orn
thoro86217873th_oro
thoron94713903thoron
thorp104414263th_orp
tora47545993__tora
whoa106615203wh_o_a
whoof144612693whoo_f
whoofs15457243whoofs
whoop134211443whoo_p
whoopla1542633whoopla
whoops14487863whoops
whoosh15244353whoosh
whore116018043wh_ore
whorl114612453wh_orl
whort114623693wh_ort

Search took 6 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.373479064.3
2DLD Change Limit1127162285.41020834.8
3Display Results2282280.0902533.3
 (SQL Overall)1786912285.87330425.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.