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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
centricities166640(None) 
centralities1448622centralities
eccentricities1792162eccentricities
canonicities1654703canonicities
centricity1746043centricit__y
concentricities1872913concentricities
conicities14412633con__icities
egocentricities2071773egocentricities
electricities1755223electricities
febricities1844943fe_bricities
gentilities1249133gent_ilities
mendicities1646383men_dicities
septicities1547313sept_icities
atrocities1248594__atrocities
caninities12410494can__inities
captivities1845944capt_ivities
causticities1654004causticities
cecities12312044ce____cities
celerities1289774celer__ities
centiliter1245654cent_ilit_er
centiliters1343914cent_iliters
centralises1349294centrali_ses
centralizes2249424centrali_zes
centrifuges1752874centri_fuges
centrioles1245804centr__ioles
centrists11410234centri_st__s
certainties1353764certai_nties
cervicitis1752804ce_rviciti_s
cervicitises1952184ce_rvicitises
chlorinities1754184chlorinities
chronicities1955124chronicities
clonicities1546184c_lonicities
complicities2055964complicities
congruities1455194congr_uities
conspicuities1962584conspicuities
contiguities1554444contiguities
continuities1456244continuities
contrarieties1563814contrarieties
contributes1565344contribut_es
creativities1755784creat_ivities
cubicities1646824c__ubicities
cyclicities1754704c_yclicities
dentalities1249544dent_alities
encrinites1244864_encrinit_es
endemicities1754024_endemicities
enormities1246904_enor_mities
entireties1047274_ent_ireties
entities8617414_ent___ities
entreaties1048114_entr_eaties
entrecotes1244334_entrecot_es
ethnicities1655444_ethnicities
extralities1848234_extralities
extremities2053804_extremities
extricates1998244_extricat_es
facticities1846874fact_icities
febrilities1645144fe_brilities
felicities1549744fe__licities
feracities1548714fe__racities
ferocities1548244fe__rocities
fertilities1448824fert_ilities
festivities1746584fest_ivities
fetidities1447874fe_t_idities
generalities1347014generalities
generosities1353814generosities
gentrices1258914gentric___es
gentrifies1446894gentr__ifies
helicities1549854he__licities
historicities1853154historicities
iconicities1556664icon__icities
intricacies1554474_intricacies
ionicities12410034ion__icities
lubricities1545074_lubricities
mendacities1645094men_dacities
mentalities13410024ment_alities
metricates1449114me_tricat_es
metricizes2346764me_trici_zes
neutralities1246464neutralities
putridities1444914_putridities
rentabilities15411264rentabilities
restrictives1755084restrictives
rusticities1346844rust_icities
sectilities1348694sect_ilities
seismicities1653374seismicities
senilities10312994sen__ilities
sphericities19134204sphericities
tenabilities14911494tenabilities
tenacities1248584ten__acities
tensilities1147654ten_silities
tonicities12410364ton__icities
trinities9313344___trinities
ventricles1544524ventric__les
veracities1549504ve__racities
vorticities1647084vort_icities

Search took 9 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 Limit124790938.44014785.5
3Display Results93930.0601550.0
 (SQL Overall)178691938.89020100.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.