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

195 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
waeful123812(None) 
wakeful1735611wakeful
wameful1535671wameful
woeful1236361woeful
awful1178142_awful
bagful1237212bagful
baleful1238002baleful
baneful1237892baneful
cageful1356482cageful
canful11610262canful
capful1368172capful
careful1249112careful
carful11610972carful
dareful1157052dareful
earful958962earful
easeful1037292easeful
eyeful1235902eyeful
fateful1397512fateful
hateful13107682hateful
hatful12108742hatful
ireful948712ireful
jarful1646682jarful
lapful1156482lapful
lawful1235492lawful
manful11610212manful
pageful1346352pageful
panful1179742panful
rueful948202rueful
swayful1643002swayful
useful947012useful
vatful12107082vatful
wailful1344952wailful
wamefuls1643862wamefuls
wasteful14104932wasteful
waul76927312wa__ul
wilful1235962wilful
woful1158172w_oful
afoul8510193_afoul
aidful1057073aidful
aimful1166703aimful
ampul91110853_ampul
annul55813383_annul
armful1167163armful
artful968273artful
babul96317713ba_bul
bagfuls1334753bagfuls
bagsful1344893bagsful
bashful1556553bashful
befoul1137253_befoul
blameful1543813blameful
boatful1236283boatful
boxful18145273boxful
caecal103713733caecal
caecum1238183caecum
cagefuls1484343cagefuls
canfuls1248423canfuls
cansful1236833cansful
capfuls1436523capfuls
carfuls1249133carfuls
caul65630003ca__ul
cupful1356423cupful
daedal849083daedal
defuel10348933_defuel
direful1156613direful
doleful1146333doleful
earfuls1036863earfuls
eyefuls1343843eyefuls
factful1536373factful
faecal11359813faecal
farfal123410183farfal
farfel124310433farfel
fearful1345593fearful
fitful1256333fitful
fretful1346143fretful
gainful1145833gainful
gleeful1144323gleeful
graceful1445393graceful
grateful1245403grateful
haemal113811643haemal
hamaul114210873hamaul
handful14127253handful
hangul1049213hangul
harmful1535763harmful
hasteful14105253hasteful
hatfuls1386023hatfuls
hatsful13106193hatsful
haul75530453ha__ul
headful1445563headful
heedful1444313heedful
hopeful1545903hopeful
jarfuls1754773jarfuls
jarsful1744603jarsful
joyful1943843joyful
jugful1734603jugful
ladleful1243283ladleful
lapfuls1234503lapfuls
lifeful1344613lifeful
maul64830723ma__ul
moanful12105003moanful
mugful1235403mugful
museful1245883museful
naevus934593naevus
needful1143863needful
pagefuls1474343pagefuls
pailful1236103pailful
painful1246403painful
palmful1445053palmful
panfuls1237173panfuls
peaceful1545463peaceful
peepul1035783peepul
pipeful1445643pipeful
plateful1345433plateful
playful1544653playful
potful1138083potful
rackful1645873rackful
refel84920813_refel
refuel93912623_refuel
sackful1645353sackful
saul45836523sa__ul
shameful1644283shameful
sinful938803sinful
sobful1136333sobful
spadeful1443963spadeful
stageful1244453stageful
tableful1344183tableful
tactful1236163tactful
tael46030713tae__l
tankful1445163tankful
tasteful11115223tasteful
tearful1046033tearful
teenful1045563teenful
tinful938043tinful
topful1136543topful
trayful1344583trayful
tubful1136683tubful
tuneful1046123tuneful
vatfuls1384853vatfuls
wadmal1237283wadmal
wadmel1235523wadmel
wadmol1234053wadmol
wae67556953wae___
waes76048603wae__s
waesuck1643093waesuck
wafer114417643wa_fer
wafers124316143wafers
wafery15398693wafery
waff134228043wa_f_f
waffed16459793waffed
waffie15338563waffie
waffle15369183waffle
waffly18305433waffly
waffs146315473wa_ffs
waft106139003wa_f_t
wafts116920553wa_fts
waif105836753waif__
waifed134011033waifed
waifs115719873waif_s
wail75238823wa__il
wakefully2243483wakefully
walkup1534193walkup
wall76236103wa__ll
walnut939433walnut
walrus956433walrus
wamefou1542293wamefou
wamefous1643763wamefous
wammus13426733wammus
wampum15406053wampum
wampus13499013wampus
wamus105514683wa_mus
wangun1037103wangun
warmup1335343warmup
washup1435323washup
watchful1943753watchful
wauk115220593wa__uk
wauls86120553wa__uls
waur76819903wa__ur
wawl105321943wa__wl
weal75838683w_e_al
weariful1443573weariful
weasel93410523weasel
wedel94513963w_edel
weel75834083w_e_el
weevil1295433weevil
weft105435013w_ef_t
wefts116715493w_efts
well75832043w_e_ll
wheal115716183whe_al
wheel115515333whe_el
willful1344533willful
wishful1664503wishful
wistful1365713wistful
woefully1744183woefully
wrackful2043093wrackful
wrathful1743613wrathful
wreckful2042443wreckful

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 Filter1786911127160.810220606.2
2DLD Change Limit1127161955.58020200.0
3Display Results1951950.0603250.0
 (SQL Overall)1786911956.45027704.0
 
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.