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 “dexterities” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

135 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
dexterities194582(None) 
alterities10411063_alterities
austerities1145723austerities
celerities1289773ce_lerities
dentalities1249543dentalities
deuterates1149083deuterat_es
deuterides1245253deuteri_des
dexterity2044343dexterit__y
dextrines1798313dext_ri_nes
enteritides1245853_enteritides
enteritis9411323_enteriti_s
enteritises1147733_enteritises
esterifies1347153_esterifies
eternities1048063_e_ternities
extensities1885763_extensities
extremities2053803_extremities
legerities1196883le_gerities
posterities1369043posterities
severities1348523se_verities
temerities1268493te_merities
ambidexterities2791044ambidexterities
arteritides1254704_arteritides
arteritis949784_arteriti_s
asperities1249774_asperities
celebrities15134454celebrities
deaerates10313644de_aerat_es
deaneries10310834deaner__ies
debilities13411294de_bilities
decertifies1744574de_certifies
declivities1745724declivities
deerflies1343924de__erflies
deformities1744284deformities
deities82621924d___e_ities
demerited1339074de_merit_ed
demeriting1448684de_meriting
demerits11310764de_merit__s
dendrites1147934de_ndrit_es
denitrifies1544264denitrifies
densities10310794de__nsities
depravities1744084depravities
desertifies1544704de_sertifies
destinies10410844dest__inies
detectives1645784de_tectives
detentes92712874de_te_nt_es
deterges101510094de_ter__ges
determines1358434de_termines
detersives1444954de_tersives
detoxifies2143604de_toxifies
detrition1049134de_t_rition
detritions1148954de_t_ritions
detritus945474de_t_rit_us
deuterate1049514deuterat_e_
deuterated1247544deuterat_ed
deuterating1347274deuterating
deuteration1249104deuteration
deuterations1348084deuterations
deuteride1145544deuteri_de_
deuteriums1343704deuteri_ums
devitrifies1852874devitrifies
dewberries1643544dewber_ries
dexterous1745554dexter__ous
dextrine1688254dext_ri_ne_
dextrins16117824dext_r__ins
dextroses1745664dext_r_oses
disparities1446794disparities
diversities1555884d_iversities
dolerites101410894d_olerit_es
ductilities1446204ductilities
duplexities2151944duplexities
eateries8324324_eater__ies
elaterites1048284elaterit_es
entireties1047274_entireties
entities8617414_ent__ities
entreaties1048114_entreaties
esterified1445404_esterified
etherifies1645284_etherifies
exiguities1843754_exiguities
expedites1946164_expedit_es
expertise1847934_exper_tise
expertises1947104_expertises
expertizes28106014_expertizes
exteriorise1854644_exteriorise
exteriorises1954214_exteriorises
exteriorities2053634_exteriorities
exteriorizes2853614_exteriorizes
exteriors1647344_exteri_ors
extermines1947784_extermines
externalities2055184_externalities
externes1539834_exter__nes
extralities1848234_extralities
ferities111416724___ferities
fertilities1448824fertilities
festivities1746584festivities
feteritas1264904fe_terit_as
fetidities1447874fe_tidities
fraternities1552944fraternities
futurities1345424_futurities
gentilities1249144gentilities
gentrifies1446904gent_rifies
geyserites1463694geyserit_es
heredities1447224he_redities
identities1146954ident__ities
integrities1247784_integrities
interties9320344_inter_ties
inverities13410624_inverities
jequirities2753564jequirities
laterites9715084_laterit_es
maternities1346014_maternities
maturities1248454_maturities
mentalities13410024mentalities
meteorites1247614me_teorit_es
meteoritics1553544me_teoritics
metrifies1439804me_t_rifies
metritis1049194me_t_riti_s
metritises1247284me_t_ritises
paternities1345794_paternities
perversities1754454perversities
petrifies14310364pe_t_rifies
preterites12411804preterit_es
quaternities2152514quaternities
reiterates10412014reiterat_es
reverifies1645974re_verifies
sectilities1348694sectilities
securities1248554se_curities
seniorities1148134seniorities
septicities1547314septicities
serenities10411074se_renities
sextettes1643924sexte__ttes
sexualities1857404sexualities
sincerities1347104sincerities
texturizes2643964texturi_zes
velleities1344934velle_ities
verities111418044___verities
wernerites1344954wernerit_es
westerlies1345614wester_lies

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit1488191358.79616918.9
3Display Results1351350.0761776.3
 (SQL Overall)1786911359.29519224.4
 
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.