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

160 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
dhootie113645(None) 
dhooti1035641dhooti_
dhooties1237631dhooties
dhootis1135661dhootis
bootie85421152_bootie
cootie84223072_cootie
dhoolies1246962dhoolies
dhoti9310102dh_oti_
dhotis1038952dh_otis
doobie94712682d_oobie
doolie73916832d_oolie
doozie163910642d_oozie
footie94718132_footie
hogtie102711762_hogtie
hoodie105116132_hoodie
hoolie93217772_hoolie
hootier104915342_hootier
hottie92514362_hottie
shortie10411322shortie
whoopie15295922whoopie
bhistie1236763bhistie
bhoot104322093bhoot__
bhoots11459903bhoot_s
blooie83913193bloo_ie
boobie104015293_boobie
boogie93515993_boogie
bookie123516003_bookie
bootee84323023_bootee
booties94124613_booties
brookie1347373brookie
chaotic14310013chaotic
choose115116143choo_se
choosier1337163choosier
chortle124210443chortle
chowtime1842943chowtime
cookie123716043_cookie
coolie83821603_coolie
coontie9311413coontie
cooties93725733_cooties
dautie72914693d_autie
dawtie103011093d_awtie
demote94817803demot_e
demotic12412333demotic
denote74118043denot_e
denotive1238673denotive
deontic1038883deontic
devote104513783devot_e
devotee113811823devotee
dhobi1136963dh_obi_
dhobis1236103dh_obis
dhole95215363dh_o_le
dhooly13457143dhoo_ly
dhoora1035653dhoo_ra
dhooras1135943dhooras
dhurrie1153943dhurrie
dhuti937523dh_uti_
dhutis1035923dh_utis
dioptre1055763dioptre
diorite8314913diorite
dobie84920333d__obie
doggie93910893d_oggie
dogie75222793d__ogie
donsie7613643d_onsie
doobies103915673d_oobies
doodies94218773d_oodies
doodle83212853d_oodle
doolee73018953d_oolee
doolies83920713d_oolies
doomier103610123d_oomier
doozies173812723d_oozies
dormie9312623d_ormie
dote55442883d__ot_e
dotier73917033d__otier
dottier83910923d_ottier
dottle74212503d_ottle
dowie94721143d__owie
doxie136017153d__oxie
droolier936073droolier
droopier1145573droopier
duotone836893duotone
flooie93712153floo_ie
floosie10378933floosie
floozie19295453floozie
foodie104413843_foodie
footier104115113_footier
footies103721543_footies
footle93914383_footle
footsie1047643_footsie
ghostier1235383ghostier
ghoulie1144253ghoulie
goodie83613993_goodie
goonie73615563_goonie
hoagie102310003_hoagie
hogtied12226653_hogtied
hogties112813993_hogties
homie104622523_h_omie
honkie133011663_honkie
hoochie1537793_hoochie
hoodier113812973_hoodier
hoodies113419833_hoodies
hookier143811673_hookier
hookies144017443_hookies
hoopoe11911233_hoopoe
hoot75752093_hoot__
hootch14386403_hootch
hooted104422653_hooted
hooter94123923_hooter
hootiest113115643_hootiest
hooting113919873_hooting
hoots84830243_hoot_s
hooty115022433_hoot_y
hostile10312553_hostile
hotties103016953_hotties
howdie13349723_howdie
kookie9389833_kookie
looie55624243_loo_ie
loonie64216453_loonie
noogie73612313_noogie
nookie103712433_nookie
oorie53026363__oorie
ootid61416693__ootid
patootie1046303patootie
photic133316423ph_otic
postie84123963_postie
prostie91617743prostie
rhotic112711213rh_otic
roofie93411173_roofie
rookie103613263_rookie
roomie83013873_roomie
rootier74915393_rootier
rootle63214453_rootle
scottie937443scottie
sheltie10109893sheltie
shoot84235893shoot__
shooter103013973shooter
shooting122812843shooting
shoots94619343shoot_s
shortia1048173shortia
shorties11414573shorties
shote85526083sh_ot_e
showtime1643733showtime
smoothie1344873smoothie
snootier8278373snootier
softie93312473_softie
soothe94214843_soothe
sootier73916603_sootier
sortie63621983_sortie
stoolie739713stoolie
thorite10313443thorite
toonie63617993_toonie
tootle62613813_tootle
tootsie737123_tootsie
twoonie1034423twoonie
whoopee15287513whoopee
whoopies16267373whoopies
whoosis1335443whoosis
whortle13335943whortle
woodie103513613_woodie
woolie93514483_woolie
zootier163611173_zootier

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271607.95316852.4
3Display Results1601600.0632539.7
 (SQL Overall)1786911608.17221866.3
 
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.