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

236 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
earful95896(None) 
carful11610971carful
earfuls1036861earfuls
fearful1345591fearful
jarful1646681jarful
tearful1046031tearful
armful1167162_armful
artful968272_artful
awful1178142_awful
bagful1237212bagful
canful11610262canful
capful1368172capful
careful1249112careful
carfuls1249132carfuls
dareful1157052dareful
earbud936282earbud
earl45838142ear__l
easeful1037292easeful
eyeful1235902eyeful
farfal123410182farfal
farfel124310432farfel
harmful1535762harmful
hatful12108742hatful
headful1445562headful
jarfuls1754772jarfuls
jarsful1744602jarsful
lapful1156482lapful
lawful1235492lawful
manful11610212manful
panful1179742panful
vatful12107082vatful
waeful1238122waeful
weariful1443572weariful
aerial64625713aerial
afoul8510193_afoul
aidful1057073aidful
aimful1166703aimful
ampul91110853_ampul
annul55813383_annul
arcus76918863_arcus
areal55928733_areal
arf67453373_arf__
arfs76029963_arf_s
argal65023383_argal
argil65116883_argil
argol65317263_argol
argue64818443_argue
argus66716543_argus
ariel55228973_ariel
aril45843023_ar_il
armfuls1275013_armfuls
armsful1284093_armsful
artal55525473_artal
artel56122743_artel
arum66129033_ar_um
arval86017013_arval
aryl75922343_ar_yl
babul96317713ba_bul
bagfuls1334753bagfuls
bagsful1344893bagsful
baleful1237993baleful
baneful1237893baneful
barbal104016663barbal
barbel104317073barbel
barbule1137943barbule
barbut104617003barbut
barf95844403barf__
barfed125416383barfed
barfly14339653barfly
barfs104826003barf_s
barium10313513barium
barque17239553barque
barrel84517873barrel
bashful1556553bashful
bearhug1343153bearhug
boatful1236283boatful
boxful18145273boxful
cageful1356483cageful
canfuls1248423canfuls
cansful1236823cansful
capfuls1436523capfuls
caracul1138823caracul
carcel105018673carcel
carl65144783car__l
carnal83919203carnal
carol75128613car_ol
carpal103716253carpal
carpel105418473carpel
carpus105514303carpus
carrel84718633carrel
cartel85022533cartel
carvel114817573carvel
caul65630003ca__ul
cheerful1643983cheerful
cupful1356423cupful
darnel74312183darnel
deathful1544013deathful
direful1156613direful
dreadful1343223dreadful
dreamful1452963dreamful
ear36867883ear___
earbuds1044633earbuds
eardrum10135423eardrum
eared65139503ear_ed
earflap1243273earflap
earing75235483earing
earlap837183earlap
earls56127513ear_ls
early85324123ear_ly
earmuff1543063earmuff
earn46737553ear__n
earned74818333earned
earner63617223earner
earns55927563ear_ns
earplug1042843earplug
ears46356593ear__s
earth85023053ear_th
earthly13387383earthly
earths95014593earths
earthy12399943earthy
earwax1664733earwax
earwig10114703earwig
easel54521113ea_sel
eau37450943ea__u_
eaux116618423ea__ux
ecru65819533ecr_u_
ecrus75113863ecr_us
enrol51014283enr_ol
enroll61110073enroll
ensoul638253ensoul
ervil8310303e_rvil
eyefuls1343843eyefuls
factful1536373factful
fardel104712593fardel
farfals13268503farfals
farfels13348213farfels
farl76338553far__l
fateful1397513fateful
fearfully1843893fearfully
feastful1444923feastful
fitful1256333fitful
forkful1744773forkful
formful1545183formful
furfur1235553furfur
gainful1145833gainful
hamaul114210863hamaul
handful14127253handful
hangul1049213hangul
harl75740003har__l
hartal9415473hartal
hateful13107683hateful
hatfuls1386023hatfuls
hatsful13106193hatsful
haul75530453ha__ul
headfuls1544313headfuls
heedful1444313heedful
helpful1543963helpful
hurtful1344853hurtful
ireful948713ireful
jarl115828133jar__l
jestful1745333jestful
joyful1943843joyful
jugful1734603jugful
karakul1042553karakul
lapfuls1234503lapfuls
larrup835713larrup
larum74317973lar_um
larval948503larval
maraud938943maraud
marcel103714853marcel
markup1436903markup
marl66341613mar__l
marque172410503marque
marvel113712003marvel
maul64830713ma__ul
moanful12105003moanful
mugful1235403mugful
narial6317953narial
narwal938943narwal
needful1143863needful
odorful1143483odorful
pageful1346353pageful
pailful1236103pailful
painful1246403painful
palmful1445053palmful
panfuls1237173panfuls
parcel103915473parcel
pareu74928743pareu_
pareus85420743pareus
parol74826273par_ol
parous84024163parous
parral85517533parral
parrel84515983parrel
peaceful1545463peaceful
pearl75324463pear__l
playful1544653playful
potful1138083potful
rackful1645873rackful
reargue836463reargue
regardful1451933regardful
restful1038613restful
rueful948203rueful
sackful1645353sackful
safrol937283safrol
saul45836523sa__ul
sinful938803sinful
sneerful1143553sneerful
sobful1136333sobful
swayful1643003swayful
tactful1236163tactful
tankful1445153tankful
tarnal63716503tarnal
tarsal63315273tarsal
tarsus6310513tarsus
tearfully1544143tearfully
teenful1045553teenful
tinful938043tinful
topful1136543topful
trayful1344583trayful
tubful1136683tubful
unartful1153563unartful
unfearful1552303unfearful
useful947013useful
varus85921183var_us
vatfuls1384853vatfuls
wailful1344953wailful
wakeful1735613wakeful
wameful1535673wameful
warmup1335343warmup
waul76927313wa__ul
wilful1235963wilful
woeful1236363woeful
woful1158173_woful
zarf166929123zarf__
zarfs174713623zarf_s
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.1401276364.3
2DLD Change Limit1127162365.40620850.2
3Display Results2362360.0802950.0
 (SQL Overall)1786912365.62631761.6
 
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.