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

159 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
dhootis113568(None) 
dhooti1035661dhooti_
dhootie1136471dhootie
dhooties1237641dhooties
dhotis1038971dh_otis
bhoots11459912bhoot_s
dhobis1236112dh_obis
dhoolies1246962dhoolies
dhooras1135942dhooras
dhoti9310122dh_oti_
dhutis1035942dh_utis
hoots84830252_hoot_s
shoots94619362shoot_s
whoosis1335452whoosis
agoutis8286873agoutis
bhaktis1633433bhaktis
bhoot104322103bhoot__
booths115313793_booths
bootie85421163_bootie
booties94124613_booties
boots75837973_boot_s
cahoots1238473cahoot_s
chaotic14310043chaotic
chooks155312793choo_ks
chooses125717423chooses
chotts113610993ch_otts
cloots85113693cloot_s
coatis85122603_coatis
cootie84223093_cootie
cooties93725733_cooties
coots75636843_coot_s
dacoits1079073dacoits
dahoons1137753dahoo_ns
dakoits1245293dakoits
dehorts11379773dehort_s
demotes104717673demotes
demotic12412343demotic
demotics1338753demotics
demotist11311843demotist
denotes83817003denotes
deontic1038883deontic
depots94716343depot_s
devotes113713753devotes
dhobi1136973dh_obi_
dholes104914793dh_oles
dhooly13457143dhoo_ly
dhoora1035653dhoo_ra
dhows125911223dh_o_ws
dhuti937543dh_uti_
dicots94915793dicot_s
divots104712203divot_s
doats65224883d_oat_s
doits66223673d_oit_s
doltish11118733d_oltish
dolts65626313d_olt_s
doobie94712683d_oobie
doobies103915673d_oobies
doodies94218773d_oodies
doofus1036163d_oofus
doolie73916833d_oolie
doolies83920713d_oolies
dooms85321343d_oo_ms
doors65022133d_oo_rs
doozie163910653d_oozie
doozies173812723d_oozies
dotes65836693d__otes
dots55647663d__ot_s
droits74314313droit_s
drools74412813droo_ls
droops95110963droo_ps
drouths11436483drouths
footie94718143_footie
footies103721543_footies
foots85528283_foot_s
fortis95418613_fortis
ghosts10489273ghost_s
glottis837173glottis
hogtie102711773_hogtie
hogties112813993_hogties
holts85627913_holt_s
hoodie105116143_hoodie
hoodies113419833_hoodies
hoods95124083_hoo_ds
hooeys125512313_hooeys
hoofs115721043_hoo_fs
hookas135312493_hookas
hookies144017443_hookies
hooks125027123_hoo_ks
hoolie93217783_hoolie
hoops105621073_hoo_ps
hoot75752103_hoot__
hootch14386413_hootch
hooted104422663_hooted
hooter94123933_hooter
hooters104520473_hooters
hootier104915353_hootier
hootiest113115643_hootiest
hooting113919883_hooting
hooty115022443_hoot_y
hooves124815483_hooves
hostas94515823_hostas
hosts85526703_host_s
hots78349333_h_ot_s
hottie92514383_hottie
hotties103016963_hotties
hottish13117903_hottish
houris94514583_houris
loots55431423_loot_s
moots75831663_moot_s
myosotis1344523myosotis
ootid61416703__ootid
ootids71110353__ootids
oots46446443__oot_s
photic133316443ph_otic
photics142810483ph_otics
photogs13358213photogs
photons123814433photons
photos113316643ph_otos
phots105418503ph_ot_s
pooris83916843_pooris
rhotic112711233rh_otic
roots55933673_root_s
rotis56327063__rotis
scoots85315943scoot_s
shantis103313103shantis
shoats94117083shoat_s
shogis103810943sh_ogis
shojis16348493sh_ojis
shooks134515633shoo_ks
shools94919013shoo_ls
shoos84226363shoo__s
shoot84235913shoot__
shooter103013993shooter
shooters112811583shooters
shooting122812863shooting
shootings13266063shootings
shortia1048193shortia
shortias1148093shortias
shortie10411343shortie
shorties11414583shorties
shortish1437423shortish
shorts95321743short_s
shotes95321913sh_otes
shots84730853sh_ot_s
shotts93614703sh_otts
shouts94017723shout_s
smooths12216323smooths
snoots64216683snoot_s
sooths95715593_sooths
soots55536213_soot_s
tooths96013803_tooths
toots55331873_toot_s
tsooris734693tsooris
whoofs15457243whoo_fs
whoopie15295933whoopie
whoopies16267373whoopies
whoops14487863whoo_ps
whorts125111433whort_s
whosis1237173wh_osis

Search took 7 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 Filter1786911340270.420425454.8
2DLD Change Limit1340271596.06322105.7
3Display Results1591590.0632523.8
 (SQL Overall)1786911596.54627297.7
 
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.