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

123 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
calceate123986(None) 
calcarate1347702calcarate
calcite11413782calc_ite
calculate1389872calculate
califate13310482califate
calycate1537892calycate
caseate9314782ca_seate
falcate12311612falc_ate
galeate83916782gal_eate
maleate94117542mal_eate
paleate94120002pal_eate
acerate92818913_a_cerate
acetate92514753_a_cetate
acuate8315633_a_cuate
aculeate1039913aculeate
alate55340323_al__ate
alcade91111513_alc_ade
alienate8311553_alienate
arcuate9311963_arcuate
aureate72515283_aureate
baccate131011263ba_ccate
baldpate1345483baldpate
calamata1247553calamata
calamite12312533calamite
calcanea1276273calc_anea
calcanei1265263calc_anei
calcar10312753calc_a_r
calcars11312653calc_ars
calces104420053calce__s
calcine11315273calc_ine
calcites12313003calc_ites
calculated1577803calculated
calculates1498703calculates
caleche14297943cal_eche
calibrate1347743calibrate
califates14310113califates
caliphate1645293caliphate
callee84327293calle__e
callet84536763calle_t_
callets93821703calle_ts
calmest11312343calmest_
calotte9510563cal_otte
calyceal1543043calycea_l
canulate10314553canulate
capitate121712183capitate
carate84734003ca__rate
carcase11312733carc_ase
carinate103320243carinate
cascade12118603casc_ade
casease939323ca_sease
caseated11310713ca_seated
caseates10313713ca_seates
casemate1239843casemate
casette9310393ca_sette
cassette1047813cassette
castrate10313863castrate
catenate10312833catenate
caudate10311353ca_udate
caveat11417723ca_veat_
caveated1439133ca_veated
caveats1239803ca_veats
cavitate13159833cavitate
celeste949653cel_este
celibate1259313celibate
cellmate1237863cellmate
chalybeate2052013chalybeate
chlorate133112693chlorate
ciliate9514603cil_iate
clavate1238713c_lavate
cleat76335063c_l_eat_
cleated103417843c_l_eated
cleats84919313c_l_eats
cleave114212513c_l_eave
climate11312833c_limate
clypeate1543873clypeate
coarctate1344823coarctate
cocreate122611813cocreate
collate92919683col_late
colocate12313433colocate
create85126373c__reate
cruciate1287313cruciate
cultrate10310873cultrate
cuneate9311723c_uneate
facete115014833fa_ce_te
falcated1438473falc_ated
fasciate1347563fasciate
galeae74717453gal_ea_e
galeated104111573gal_eated
galette84212693gal_ette
gallate83417123gal_late
glaciate1168073glaciate
kalifate1556493kalifate
lacerate102214703la_cerate
lactate9312693la_ctate
laureate888023laureate
macerate122314073ma_cerate
malate84624553mal__ate
maleates103316343mal_eates
nauseate845893nauseate
nucleate1048673nucleate
oleate6318883_ol_eate
palate84226783pal__ate
paleae84820293pal_ea_e
palette93613983pal_ette
pallette1039513pallette
palliate10311893palliate
palmate113215233pal_mate
palmette1247733palmette
palpate113213923pal_pate
pileate93815923pil_eate
placate11312433plac_ate
racemate1239063ra_cemate
raclette1047643raclette
saccate111311763sa_ccate
salivate11310013salivate
sulcate9314423sulc_ate
ulcerate1039733_ulcerate
vacate11314553va_c_ate
valerate11311473valerate
validate1239003validate
vallate103016563val_late
valuate102512733val_uate
valvate133710813val_vate

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621237.37319824.0
3Display Results1231230.0631952.4
 (SQL Overall)1786911237.60923484.2
 
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.