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

167 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
earfuls103686(None) 
carfuls1249131carfuls
earful958961earful_
jarfuls1754771jarfuls
armfuls1275012_armfuls
bagfuls1334752bagfuls
canfuls1248422canfuls
capfuls1436522capfuls
carful11610972carful_
earbuds1044632earbuds
earls56127512ear__ls
eyefuls1343842eyefuls
farfals13268502farfals
farfels13348212farfels
fearful1345592fearful_
hatfuls1386022hatfuls
headfuls1544312headfuls
jarful1646682jarful_
lapfuls1234502lapfuls
panfuls1237172panfuls
tearful1046032tearful_
vatfuls1384852vatfuls
aerials74017553aerials
ampuls1098893_ampuls
annuls64711733_annuls
arcus76918863_arcu_s
arfs76029963_arf__s
argals75517713_argals
argils75213623_argils
argols74514613_argols
argues74516413_argues
argus66716543_argu_s
ariels65119373_ariels
arils58732203_ar_ils
armful1167163_armful_
artels66216233_artels
artful968273_artful_
arums75517833_ar_ums
aryls87015813_ar_yls
awful1178143_awful_
babuls105413643ba_buls
bagful1237213bagful_
barbels114514433barbels
barbule1137943barbule
barbules1238043barbules
barbuts11439843barbuts
barfly14339653barf_ly
barfs104826003barf__s
bariums1139143bariums
barques18259643barques
barrels94514363barrels
bearhugs1442523bearhugs
boatfuls1344823boatfuls
boxfuls19113603boxfuls
cagefuls1484343cagefuls
canful11610263canful_
capful1368173capful_
caraculs1238033caraculs
carcels114516063carcels
careful1249113careful_
carls77037423car__ls
carols85124983car_ols
carolus94612603carolus
carpals113414623carpals
carpels115315463carpels
carpus105514303carpu_s
carrels95117303carrels
cartels94618123cartels
carvels124914593carvels
cauls75727773ca__uls
cupfuls1444343cupfuls
dareful1157053dareful_
darnels83710433darnels
dreadfuls1442533dreadfuls
earbud936283earbu_d
eardrums11524483eardrums
earflap1243273earflap
earflaps1342553earflaps
earings84517713earings
earl45838143ear__l_
earlaps936393earlaps
earless74316073earless
early85324123ear__ly
earmuff1543063earmuff
earmuffs1641373earmuffs
earners74016453earners
earns55927563ear__ns
earplug1042853earplug
earplugs1142243earplugs
ears46356593ear___s
earthly13387383earthly
earths95014593ear_ths
earwigs11104413earwigs
easeful1037293easeful_
easels65914553ea_sels
ecrus75113863ecr_u_s
enrolls7108093enrolls
enrols61213383enr_ols
ensouls736033ensouls
ervils948773e_rvils
eyeful1235903eyeful_
fardels11389893fardels
farfal123410183farfal_
farfel124310433farfel_
farls85731113far__ls
fearfully1843893fearfully
forkfuls1843553forkfuls
hamauls12387813hamauls
handfuls15115753handfuls
harls85634503har__ls
harmful1535763harmful_
hartals10313023hartals
hatful12108743hatful_
hauls86123733ha__uls
headful1445563headful_
jarls126120963jar__ls
jarsful1744603jarsful_
jugfuls1843063jugfuls
karakuls1142083karakuls
lapful1156483lapful_
larrups934733larrups
larums83610533lar_ums
lawful1235493lawful_
manful11610213manful_
marauds1037553marauds
marcels113212373marcels
markups1534963markups
marls75535163mar__ls
marques182610863marques
marquis18247063marquis
marvels123810093marvels
mauls76524953ma__uls
mugfuls1344003mugfuls
narwals1036983narwals
needfuls1242403needfuls
pagefuls1474343pagefuls
pailfuls1343843pailfuls
palmfuls1543473palmfuls
panful1179743panful_
parcels113712663parcels
pareus85420743pareu_s
parols84722613par_ols
parous84024163parou_s
parrals94414573parrals
parrels94713493parrels
pearls84715393pear__ls
potfuls1236293potfuls
rackfuls1744643rackfuls
reargues936713reargues
sackfuls1744163sackfuls
safrols1036863safrols
sauls55128123sa__uls
tankfuls1543803tankfuls
tarsals72512603tarsals
tarsus6310513tarsu_s
tearfully1544143tearfully
tinfuls1036593tinfuls
trayfuls1443483trayfuls
tubfuls1245483tubfuls
varus85921183var_u_s
vatful12107083vatful_
waeful1238123waeful_
wamefuls1643863wamefuls
warmups1433813warmups
wauls86120553wa__uls
weariful1443573weariful_
zarfs174713623zarf__s

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271676.70319995.1
3Display Results1671670.0463630.4
 (SQL Overall)1786911677.18524870.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.