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

274 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
awful117814(None) 
lawful1235491lawful
afoul8510192afoul
aidful1057072aidful
aimful1166702aimful
ampul91110852ampul
annul55813382annul
armful1167162armful
artful968272artful
awfully1644002awfully
awl67635302aw__l
awol75620672aw_ol
bagful1237212bagful
canful11610262canful
capful1368172capful
carful11610972carful
earful958962earful
hatful12108742hatful
jarful1646682jarful
lapful1156482lapful
manful11610212manful
panful1179742panful
vatful12107082vatful
waeful1238122waeful
waul76927312_waul
woful1158172woful
aal39058673a__al
aboil72217543aboil
about75229083about
abut66834953a_but
actual8311023actual
acyl95314293a_cyl
adult63520653a_dult
afar76720783a_far
aff95537613a_f_f
affix1836003affix
afflux1942793afflux
aft66849013a_f_t
ague55725923a_gue
ahull84010313ahull
ail37171043a__il
al210674043a___l
album92312653album
aldol61212333aldol
alfa77624273alf_a
alfas87219043alfas
algal66518223algal
algum82711763algum
alkyl12518043alkyl
all36148233a__ll
allyl85310543allyl
almud84012183almud
almug8429303almug
aloud65018073aloud
alula5317093a_lula
alum65227613a_lum
amour75014853amour
ampule10710613ampule
ampuls1098893ampuls
amu58237323a_mu_
amus65529613a_mus
amyl95515103a_myl
anal48037523a_nal
angel65019563angel
anil46437433a_nil
ankus91410683ankus
annal56520763annal
annual64710703annual
annuli6459053annuli
annuls64711733annuls
anus47131113a_nus
anvil82712603anvil
appal95315223appal
appel94615893appel
aqua132813963a_qua
arcus76918863arcus
areal55928733areal
arf67453373arf__
arfs76029963arf_s
argal65023393argal
argil65116883argil
argol65317263argol
argue64818443argue
argus66716543argus
ariel55228973ariel
aril45843023a_ril
armfuls1275013armfuls
armsful1284093armsful
artal55525473artal
artel56122743artel
arum66129033a_rum
arval86017013arval
aryl75922343a_ryl
ascus75013583ascus
aswirl935093aswirl
atoll57913923atoll
augur64311213augur
auk76234143a__uk
auld54125363a__uld
aural54428963aural
aurum7614963aurum
avail8313883avail
aw512563403aw___
awa611939673aw__a
await85524493await
awake125014783awake
award97118043award
aware86420023aware
awash116613163awash
away108024223aw_ay
awe67746623aw__e
awed88436033aw_ed
awee76336643aw_ee
awes76037553aw_es
awfuller1442423awfuller
awhile1257793awhile
awhirl1264673awhirl
awing96827323awing
awls75926093aw_ls
awmous1157713awmous
awn68035913aw__n
awned96615953awned
awns75324433aw_ns
awny105919303aw_ny
awoke124912003awoke
awols84713523awols
awry107619683aw_ry
axal116520493a_xal
axel115222073a_xel
axial124515193axial
axil116424453a_xil
babul96317713babul
bagfuls1334753bagfuls
bagsful1344893bagsful
baleful1238003baleful
baneful1237893baneful
bashful1556553bashful
bawl95326063baw__l
befoul1137253befoul
boatful1236283boatful
bowlful1544613bowlful
boxful18145273boxful
cageful1356483cageful
canfuls1248423canfuls
cansful1236833cansful
capfuls1436523capfuls
careful1249113careful
carfuls1249133carfuls
caul65630003_caul
cupful1356423cupful
dareful1157053dareful
defuel10348933defuel
dufus94010813dufus
dwell9519853dwell
earfuls1036863earfuls
easeful1037293easeful
eyeful1235903eyeful
factful1536373factful
farfal123410183farfal
farfel124310433farfel
fateful1397513fateful
fearful1345593fearful
fil65447143__fil
fitful1256333fitful
flu66530213__flu
foul77027583_foul
fub86337393__fub
fud76335153__fud
fuel76824733__fuel
fug76234513__fug
full75229153__full
fun66841143__fun
fur66637323__fur
furl77030883__furl
gainful1145833gainful
ghoul959053ghoul
gul45832793__gul
hamaul114210873hamaul
handful14127253handful
hangul1049213hangul
harmful1535763harmful
hateful13107683hateful
hatfuls1386023hatfuls
hatsful13106193hatsful
haul75530453_haul
headful1445563headful
ireful948713ireful
jarfuls1754773jarfuls
jarsful1744603jarsful
joyful1943843joyful
jugful1734603jugful
lapfuls1234503lapfuls
lawfully1743503lawfully
maul64830723_maul
miaul71612123miaul
moanful12105003moanful
mogul8310213mogul
mugful1235403mugful
offal1136243offal
owl66228973ow__l
pageful1346353pageful
pailful1236103pailful
painful1246403painful
palmful1445053palmful
panfuls1237173panfuls
pawl95123263paw__l
pfui9349793_pfui
picul95015363picul
playful1544653playful
potful1138083potful
pul56138063__pul
rackful1645873rackful
refel84920813refel
refuel93912623refuel
rueful948203rueful
sackful1645353sackful
saul45836523_saul
sawfly1535133sawfly
schul102510413schul
shaul85418103shaul
shul75823153_shul
sinful938803sinful
sobful1136333sobful
soul46435713_soul
swail86217163swail
swayful1643003swayful
swell84815983swell
swill83417373swill
swirl84514143swirl
swoun84811493swoun
swum96416823sw_um
tactful1236163tactful
tankful1445163tankful
tearful1046033tearful
tinful938043tinful
tofu76921333tofu_
tofus86415423tofus
topful1136543topful
trayful1344583trayful
tubful1136683tubful
twill85612723twill
twirl85011943twirl
unfurl937953unfurl
unlawful1441783unlawful
useful947013useful
vatfuls1384853vatfuls
wafer114417643wafer
waff134228043waf_f
waffle15369183waffle
waffly18305433waffly
waffs146315473waffs
waft106139003waf_t
wafts116920553wafts
wail75238823_wail
wailful1344953wailful
wakeful1735613wakeful
wall76236103_wall
wameful1535673wameful
wamus105514683wamus
wauk115220593_wauk
wauls86120553_wauls
waur76819903_waur
wawl105321943_wawl
weal75838683_weal
weel75834083_weel
well75832043_well
whup125714163_whup
wilful1235963wilful
will75737513_will
woeful1236363woeful
wool76427373_wool
would95513153_would
wud76227153_w_ud
yawl104918973yaw__l

Search took 5 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 Filter178691836670.343520965.0
2DLD Change Limit836672743.65622884.8
3Display Results2742740.0763605.3
 (SQL Overall)1786912744.07543850.6
 
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.