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

133 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
hatfuls138602(None) 
hatful12108741hatful_
vatfuls1384851vatfuls
bagfuls1334752bagfuls
boatfuls1344822boatfuls
canfuls1248422canfuls
capfuls1436532capfuls
carfuls1249132carfuls
earfuls1036862earfuls
hamauls12387822hamauls
handfuls15115752handfuls
hateful13107682hateful_
hatsful13106192hatsful_
hauls86123732ha__uls
headfuls1544312headfuls
jarfuls1754772jarfuls
lapfuls1234502lapfuls
panfuls1237182panfuls
potfuls1236292potfuls
vatful12107082vatful_
ampuls1098893_ampuls
annuls64711733_annuls
armfuls1275013armfuls
artful968273artful_
atolls65511353_atolls
awful1178143_awful_
babuls105413643ba_buls
bagful1237213bagful_
batfowls1642773batfowls
battues94610193battues
boatful1236283boatful_
boxfuls19113603boxfuls
cagefuls1484343cagefuls
canful11610263canful_
capful1368183capful_
carful11610973carful_
catfall1237393catfall
catfalls1347063catfalls
catguts1045323catguts
catsups1135343catsups
cauls75727773ca__uls
chattels13286793chattels
chestfuls1742883chestfuls
cupfuls1444343cupfuls
datums936353dat_ums
earful958963earful_
eyefuls1343843eyefuls
factful1536373factful_
faithfuls1842303faithfuls
farfals13268503farfals
farfels13348213farfels
fateful1397513fateful_
fistfuls1454563fistfuls
fitful1256333fitful_
ghastful1543303ghastful_
haafs115711163haaf__s
habus106317143ha_bu_s
haffets1636053haffets
haffits1636193haffits
hafters134614333hafters
hafts116219463ha_f_ts
hagbuts1354933hagbuts
haikus13538293haiku_s
hails85231643ha__ils
hakus125114113ha_ku_s
halals95018313ha_lals
hallels103310133hallels
halls85633783ha__lls
hamals114816833ha_mals
hamaul114210873hamaul_
hammals14409233hammals
hamuli1137063ha_muli
hamulus1235323ha_mulus
handful14127253handful_
hangul1049223hangul_
hangups1364823hangups
hansels104011663hansels
harls85634503ha__rls
harmful1535763harmful_
hartals10313023hartals
hassels104311023hassels
hasteful14105253hasteful_
hatable121713963hatable
hatchels16368673hatchels
hatches153420273hatches
hatefully1844773hatefully
haters94930403hat_ers
hates86742573hat__es
hatless103813443hatless
hatpins123410643hatpins
hatreds11307813hatreds
hats76858253hat___s
hatters104221523hatters
haul75530453ha__ul_
haulm104415413ha__ulm
haulms11558503ha__ulms
hauteurs1133743hauteurs
hazels185710083ha_zels
headful1445563headful_
hiatus938223hiat_u_s
hopefuls1644073hopefuls
hotels94515523hot_els
hurtful1344853hurtful_
jarful1646683jarful_
jugfuls1843063jugfuls
kistfuls1553833kistfuls
lapful1156483lapful_
lawful1235493lawful_
manful11610213manful_
mauls76524953ma__uls
mugfuls1344003mugfuls
pagefuls1474343pagefuls
pailfuls1343853pailfuls
palmfuls1543473palmfuls
panful1179743panful_
patrols93513513patrols
platefuls1443963platefuls
potful1138083potful_
rackfuls1744643rackfuls
ratals64219583rat_als
ratels64518213rat_els
sackfuls1744163sackfuls
sauls55128123sa__uls
shauls94913113sha__uls
tactful1236163tactful_
tankfuls1543803tankfuls
tinfuls1036593tinfuls
trayfuls1443483trayfuls
tubfuls1245483tubfuls
vatus86114643vat_u_s
waeful1238123waeful_
wamefuls1643873wamefuls
wauls86120553wa__uls

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271336.25021444.3
3Display Results1331330.0632111.1
 (SQL Overall)1786911336.74926476.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.