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

219 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
dhooti103564(None) 
dhootie1136451dhootie
dhootis1135661dhootis
dhoti9310101dh_oti
bhoot104322092bhoot_
bhoots11459902bhoots
dhobi1136962dh_obi
dhooly13457142dhooly
dhoora1035652dhoora
dhooties1237632dhooties
dhotis1038952dh_otis
dhuti937522dh_uti
hoot75752092_hoot_
hoots84830242_hoots
hooty115022432_hooty
shoot84235892shoot_
shoots94619342shoots
afoot8420113afoot_
agouti7388763agouti
bhakti1544323bhakti
boot67759373_boot_
booth105522013_booth
bootie85421153_bootie
boots75837973_boots
booty106125913_booty
cahoot11416473cahoot_
cahoots1238473cahoots
chaotic14310013chaotic
chook146015043choo_k
chooks155312793chooks
choose115116143choose
choosy14459103choosy
chott103923923ch_ott
chotts113610983chotts
cloot76127053cloot_
cloots85113693cloots
coati75624633_coati
coot67860383_coot_
cootie84223073_cootie
coots75636843_coots
dacoit9415443dacoit
dahoon1039053dahoo_n
dahoons1137753dahoons
dakoit11310333dakoit
dehort104618103dehort_
dehorts11379773dehorts
demote94817803demote
demotic12412333demotic
denote74118043denote
deontic1038883deontic
depot85727923depot_
depots94716343depots
devote104513783devote
dhobis1236103dhobis
dhole95215363dh_ole
dholes104914793dholes
dhoolies1246963dhoolies
dhooras1135943dhooras
dhow116614003dh_o_w
dhows125911223dh_ows
dhutis1035923dh_utis
dicot85429093dicot_
dicots94915793dicots
divot95723073divot_
divots104712203divots
doat56947673d_oat_
doats65224883d_oats
doeth9411983d_oeth
doit56347853d_oit_
doits66223673d_oits
dolci84912603d_olci
dolt56649423d_olt_
dolts65626313d_olts
doobie94712683d_oobie
doody105517913d_oody
doolie73916833d_oolie
dooly94821803d_ooly
doom76430073d_oo_m
dooms85321343d_ooms
doomy116018263d_oomy
door56928513d_oo_r
doors65022133d_oors
doozie163910643d_oozie
doozy186813713d_oozy
dorty96220813d_orty
dost57248353d_ost_
dot47573183d__ot_
dote55442883d__ote
doth86225713d__oth
dots55647663d__ots
dotty94516103d_otty
doty86128223d__oty
droit65127123droit_
droits74314313droits
drool65416103droo_l
drools74412813drools
drooly104911073drooly
droop85814823droo_p
droops95110963droops
droopy12458243droopy
dropt86924433dropt_
drouth104410103drouth
duomi8310133d_uomi
foot76248013_foot_
footie94718133_footie
foots85528283_foots
footy115820533_footy
ghost96318763ghost_
ghosts10489273ghosts
ghosty13467213ghosty
hogtie102711763_hogtie
holt77852583_holt_
holts85627913_holts
hongi96715853_hongi
hooch135813703_hooch
hood85132333_hoo_d
hoodie105116133_hoodie
hoods95124083_hoods
hoody124919723_hoody
hooey114926603_hooey
hoof106036583_hoo_f
hoofs115721043_hoofs
hook116133283_hoo_k
hooka125513903_hooka
hooks125027123_hooks
hooky155220263_hooky
hoolie93217773_hoolie
hooly115022223_hooly
hoop96129983_hoo_p
hoops105621073_hoops
hootch14386403_hootch
hooted104422653_hooted
hooter94123923_hooter
hootier104915343_hootier
hooting113919873_hooting
host77852833_host_
hosta85917833_hosta
hosts85526703_hosts
hot67776053_h_ot_
hots78349323_h_ots
hottie92514363_hottie
houri85915233_houri
krooni10397183krooni
loot46955823_loot_
loots55431423_loots
loti46431833__loti
maloti8313193maloti
moot67653623_moot_
moots75831663_moots
oot311274693__oot_
ootid61416693__ootid
oots46446443__oots
phooey14379233phooey
phot95534353ph_ot_
photic133316423ph_otic
photo104417223ph_oto
photog12379803photog
photon1111514823photon
photos113316633photos
phots105418493ph_ots
poori74816233_poori
rhombi13365193rhombi
rhotic112711213rh_otic
root45655923_root_
roots55933673_roots
rooty86423023_rooty
roti46332923__roti
scoot75729143scoot_
scoots85315933scoots
shanti94014073shanti
shoat85633943shoat_
shoats94117073shoats
shogi95013993sh_ogi
shoji15419943sh_oji
shoo75929883shoo__
shooed103916073shooed
shook124920153shoo_k
shooks134515623shooks
shool84523143shoo_l
shools94919003shools
shoon84022003shoo_n
shoos84226353shoo_s
shooter103013973shooter
shooting122812843shooting
short85040523short_
shortia1048173shortia
shortie10411323shortie
shorts95321733shorts
shorty124313193shorty
shot76150243sh_ot_
shote85526083sh_ote
shots84730833sh_ots
shott85332173sh_ott
shotts93614683shotts
shout85433163shout_
shouts94017713shouts
smooth11259193smooth
snoot55030133snoot_
snoots64216663snoots
snooty94211503snooty
soot45761053_soot_
sooth85924053_sooth
soots55536203_soots
sooty84924833_sooty
tholoi9339223tholoi
toot45958883_toot_
tooth88020183_tooth
toots55331873_toots
volti84915963_volti
whoof144612693whoo_f
whoofs15457243whoofs
whoop134211443whoo_p
whoopie15295913whoopie
whoops14487863whoops
whoosh15244353whoosh
whoosis1335443whoosis
whort114623693whort_
whorts125111433whorts
zooty175415353_zooty

Search took 8 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.1701051123.5
2DLD Change Limit1127162196.72016773.2
3Display Results2192190.0932354.8
 (SQL Overall)1786912196.98325589.4
 
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.