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

215 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
hatful1210874(None) 
hateful13107681hateful
hatfuls1386021hatfuls
hatsful13106191hatsful
vatful12107081vatful
artful968272artful
awful1178142_awful
bagful1237212bagful
boatful1236282boatful
canful11610262canful
capful1368172capful
carful11610972carful
earful958962earful
factful1536372factful
fateful1397512fateful
fitful1256332fitful
ghastful1543302ghastful
hamaul114210872hamaul
handful14127252handful
hangul1049212hangul
harmful1535762harmful
hasteful14105252hasteful
haul75530452ha__ul
headful1445562headful
hurtful1344852hurtful
jarful1646682jarful
lapful1156482lapful
lawful1235492lawful
manful11610212manful
panful1179742panful
potful1138082potful
tactful1236162tactful
vatfuls1384852vatfuls
waeful1238122waeful
afoul8510193_afoul
aidful1057073aidful
aimful1166703aimful
ampul91110853_ampul
annul55813383_annul
armful1167163armful
atoll57913923_atoll
babul96317713ba_bul
bagfuls1334753bagfuls
bagsful1344893bagsful
baleful1238003baleful
baneful1237893baneful
bashful1556553bashful
batfowl1543593batfowl
battu75216613battu_
battue84311003battue
boastful1344853boastful
boatfuls1344823boatfuls
boxful18145273boxful
cageful1356483cageful
canfuls1248423canfuls
cansful1236833cansful
capfuls1436523capfuls
careful1249113careful
carfuls1249133carfuls
catfall1237393catfall
catgut9310803catgut
catsup1036433catsup
caul65630003ca__ul
chattel12388893chattel
chestful1644243chestful
cupful1356423cupful
dareful1157053dareful
datum8310633dat_um
deathful1544013deathful
dutiful1144763dutiful
earfuls1036863earfuls
easeful1037293easeful
eyeful1235903eyeful
faithful1743383faithful
farfal123410183farfal
farfel124310433farfel
fatal84819373fat_al
fearful1345593fearful
feastful1444923feastful
fistful1365903fistful
fretful1346143fretful
gainful1145833gainful
grateful1245403grateful
haaf106227733haaf__
haafs115711163haaf_s
habu97325483ha_bu_
habus106317143ha_bus
hadal95518123ha_dal
haemal113811643haemal
haffet15311703haffet
haffit1538533haffit
hafiz20611213ha_fiz
haft105941843ha_f_t
hafted134713833hafted
hafter124815883hafter
hafts116219463ha_fts
hagbut1278923hagbut
haiku126113693haiku_
haikus13538293haikus
hail74839063ha__il
haku116923893ha_ku_
hakus125114113ha_kus
halal85623593ha_lal
half106238453half__
hall75741163ha__ll
hallal94415563hallal
hallel93514093hallel
hallux1637363hallux
hamal104623113ha_mal
hamauls12387813hamauls
hammal134512063hammal
hamuli1137063ha_muli
handfuls15115753handfuls
handsful1544083handsful
hangup1277293hangup
hansel95214373hansel
harl75740003ha__rl
hartal9415473hartal
hassel95614213hassel
hat67289963hat___
hatable121713963hatable
hatbox1835133hatbox
hatch135719593hat_ch
hatchel153510753hatchel
hate78450173hat__e
hated95734023hat_ed
hatefully1844773hatefully
hater85034753hat_er
haters94930403haters
hates86742573hat_es
hath105933913hat__h
hating104929713hating
hatpin112610613hatpin
hatred104814333hatred
hats76858253hat__s
hatted104921513hatted
hatter94724873hatter
haulm104415413ha__ulm
hauls86123733ha__uls
haut75949733ha__ut
hauteur1033893hauteur
hazel176414813ha_zel
headfuls1544313headfuls
healthful1852423healthful
heedful1444313heedful
helpful1543963helpful
hiatal9310203hiat_al
hiatus938223hiat_us
hopeful1545903hopeful
hotel85520753hot_el
hushful1644333hushful
ireful948713ireful
jarfuls1754773jarfuls
jarsful1744603jarsful
jestful1745333jestful
joyful1943843joyful
jugful1734603jugful
kistful1465303kistful
lapfuls1234503lapfuls
latu47934183lat_u_
loathful1443383loathful
lustful1045283lustful
maul64830723ma__ul
moanful12105003moanful
mugful1235403mugful
natal53921493nat_al
pageful1346353pageful
pailful1236103pailful
painful1246403painful
palmful1445053palmful
panfuls1237173panfuls
patrol83213023patrol
pitiful1245863pitiful
plateful1345433plateful
playful1544653playful
potfuls1236293potfuls
poutful1236743poutful
rackful1645873rackful
ratal55025113rat_al
ratel54224883rat_el
restful1038623restful
rueful948203rueful
ruthful1344503ruthful
sackful1645353sackful
saul45836523sa__ul
shameful1644283shameful
shaul85418103sha__ul
sinful938803sinful
sobful1136333sobful
swayful1643003swayful
tankful1445163tankful
tasteful11115223tasteful
tearful1046033tearful
thankful1843253thankful
tinful938043tinful
topful1136543topful
trayful1344583trayful
tubful1136683tubful
unartful1153563unartful
useful947013useful
vatu76524333vat_u_
vatus86114643vat_us
vauntful1442473vauntful
wailful1344953wailful
wakeful1735613wakeful
wameful1535673wameful
wasteful14104933wasteful
watchful1943753watchful
waul76927313wa__ul
wilful1235963wilful
wistful1365713wistful
woeful1236363woeful
woful1158173_woful
wrathful1743613wrathful
zestful1945243zestful

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.376475242.0
2DLD Change Limit1127162155.43620735.1
3Display Results2152150.0802687.5
 (SQL Overall)1786912155.89230327.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.