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

105 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
erectilities144712(None) 
sectilities1348692_sectilities
creativities1755783creativities
directivities1954193directivities
ductilities1446203_ductilities
effectivities2453853effectivities
electabilities1857583electabilities
electricities1755223electricities
erectility1546263erectilit__y
fertilities1448823_fertilities
gentilities1249133_gentilities
gracilities1447683grac_ilities
perfectivities2483873perfectivities
reactivities1756173reactivities
retractilities1674083retractilities
selectivities1854873selectivities
tactilities1347673_tactilities
versatilities1656083versatilities
activities1548904__activities
affectivities2453514affectivities
arabilities13413104ar_abilities
bestialities1455494_bestialities
brutalities1345444br_utalities
credibilities1856074credibilities
credulities1444134cre_dulities
debilities13411294_de_bilities
decilitres1344994_dec_ilitres
declivities1745724_declivities
delectabilities2065564delectabilities
dentalities1249544_dentalities
detectabilities2065824detectabilities
disutilities1355154disutilities
docilities1349004_doc_ilities
dyeabilities1847874dyeabilities
edibilities1458704e_dibilities
educabilities1857064educabilities
effectualities2262204effectualities
elasticities1455104elasticities
electrifies1645744elect_rifies
emotivities1645754e_motivities
equabilities2348154equabilities
erasabilities1549634erasabilities
erectile1039514erectil___e_
ergodicities1653734ergodicities
erodibilities1656884erodibilities
erosivities1455914er_osivities
essentialities1473244essentialities
eventualities1653514eventualities
facilities1549824_fac_ilities
facticities1846874_facticities
febrilities1645144_febrilities
festivities1746584_festivities
fetidities1447874_fe_tidities
fragilities1547164fr_agilities
friabilities1789174friabilities
frontalities1555574frontalities
futilities1348864__futilities
hostilities14127654_hostilities
imbecilities1853654imbec_ilities
inactivities1755594inactivities
infectivities2155124infectivities
infertilities1656214infertilities
inutilities1148184_inutilities
mentalities13410024_mentalities
motilities12410584__motilities
nonutilities1256684nonutilities
objectivities2754314objectivities
overactivities2274464overactivities
perceptivities2363264perceptivities
permeabilities2056844permeabilities
practicalities2053564practicalities
preciosities1655374preciosities
precipitins1746174prec_ipitins
precocities1748164prec_ocities
proclivities1964684proclivities
puerilities1347534pue_rilities
realities9316314_re__alities
receptivities2053904receptivities
rectifies14310814_rect__ifies
reflectivities2263624reflectivities
refractivities22103974refractivities
regalities11410594_re_galities
relativities1555774relativities
rentabilities15411264_rentabilities
resectabilities1956024resectabilities
retentivities1654544retentivities
retinites9313504_re_tinit_es
retinitides1244744_re_tinitides
retinitis948024_re_tiniti_s
retinitises1145984_re_tinitises
reutilizes1947124_reutili_zes
rusticities1346844_rusticities
senilities10312994_se_nilities
septicities1547314_septicities
serendipities1662624serendipities
servilities1447054_servilities
sessilities1146404_sessilities
specialities1656794specialities
sterilities11129014ste_rilities
subtilities1347854_subtilities
tensilities1147654_tensilities
tractabilities1846614tractabilities
treatabilities1657624treatabilities
utilities9610804___utilities
volatilities1546514volatilities

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901056.62618833.4
3Display Results1051050.0601750.0
 (SQL Overall)1786911057.07625253.1
 
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.