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

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

154 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
desegregating175273(None) 
resegregating1652841resegregating
desegregation1663812desegregation
desegregations1763562desegregations
segregating1445452__segregating
desecrating1548093desecr__ating
desegregate1453013desegregat__e
desegregated1652803desegregat_ed
desegregates1552933desegregat_es
disaggregating1762153disaggregating
reaggregating1552563reaggregating
resegregation1563903resegregation
resegregations1653693resegregations
aggregating1343584__aggregating
congregating1754284_congregating
deaerating12311564deae_r__ating
decelerating1645594dece_lerating
decerebrating1953204dece_rebrating
degenerating1545664dege_nerating
degreasing1345424d__egre_asing
delegating1337674d__e_legating
denervating1645924dene_r_vating
denigrating14146924denigr__ating
deprecating1777284d__eprecating
depredating1655694d__epredating
deregulating1554014dereg_ulating
derogating1348634d__e_rogating
deselecting1544474dese_le_cting
deserting11713144dese_r___ting
desiderating1544694des_iderating
designating1446074desig__nating
estreating11710364_es_tre_ating
peregrinating1752974peregrinating
resegregate1352974resegregat__e
resegregated1552804resegregat_ed
resegregates1452784resegregat_es
revegetating1753684reveg_etating
segregation1346384__segregation
segregations1445804__segregations
segregative1654064__segregative
asseverating1652275asse_verating
bespreading1743505bes_pre_ading
celebrating1646115celebr__ating
cerebrating1646665cerebr__ating
decorating14312075de_cor__ating
decreasing1446525d__ecre_asing
defeating142311975d__e_fe_ating
defecating17237785d__e_fecating
defibrinating2052465defibrinating
deflagrating1852665deflagr__ating
deforesting1654795de_fore_sting
degrading13137375d__egr__ading
dehydrating2043655dehydr__ating
delectating1545995dele__ctating
deliberating1645125de_liberating
delineating1346375de_line_ating
demarcating1745205de_mar_cating
demergering1653595deme_r_gering
demerging1436645deme_r_g__ing
demeriting1448685deme_r__iting
denitrating13128335denitr__ating
deoxygenating26101625deoxygenating
depreciating1845035d__epreciating
depurating1438645de_pur__ating
derating103222285d__e_r__ating
derepressing1653575derepre_ssing
desalinating1476315des_alinating
desecration14410075desecr__ation
desecrations1559215desecr__ations
desertifying2092875dese_rtifying
deserving1497905dese_r___ving
desiccating1744705des__iccating
desolating1239465des___olating
despumating1743695des__pumating
desquamating2551755des_quamating
destructing1546115des_tr_ucting
desugaring1343265des___ugaring
deterging1237855dete_r_g__ing
deteriorating1553395deteriorating
deuterating1347275d__euterating
disaggregation1862695disaggregation
disaggregations1962515disaggregations
disaggregative2171595disaggregative
disagreeing1453865disagre__eing
discrediting1753215dis_crediting
disengaging1553475dise__ngaging
disgracing1586745dis_gr__acing
disintegrating1763305disintegrating
dispreading1645915dis_pre_ading
disrating11714555dis__r__ating
disregarding1652535dis__regarding
disseating121111785dis__se_ating
dissertating1474795disser_tating
emigrating1467505_emigr__ating
enervating1488435_ene_r_vating
entreating11811555_e_ntre_ating
escheating1645885_es_che_ating
exaggerating2253185_exaggerating
execrating2047885_execr__ating
exenterating2054215_exenterating
expurgating2243285_expur_gating
federating1548855fede_r__ating
generating12310385gene_r__ating
integrating1349495integr__ating
interrelating1457295interrelating
interrogating1556665interrogating
miscreating1648495mis_cre_ating
misrelating1447275mis__relating
mistreating1449285mis_tre_ating
nonsegregation16132805nonsegregation
nonsegregations17162695nonsegregations
obsecrating1644135obsecr__ating
overeating141016535_ove_re_ating
penetrating1447665penetr__ating
perseverating1952525perse_verating
pretreating1448895_pretre_ating
reaggregation1653145reaggregation
reaggregations1762845reaggregations
recreating131214585__recre_ating
redefeating1645335rede_fe_ating
reelevating1544965re_e_levating
reerecting1339975re_e_re_cting
regelating1239955__reg_elating
regenerating1446335rege_nerating
regrating111316215__regr__ating
regreeting1237345__regre_eting
regretting1237785__regre_tting
relegating1239485__re_legating
remigrating1547595remigr__ating
renegotiating1552245renegotiating
reregulating1454645rereg_ulating
rerepeating1447185rere_pe_ating
reseating102421535res___e_ating
reselecting1446025rese_le_cting
respreading1545175res_pre_ading
resurrecting1553125resurre_cting
retreating111414775__retre_ating
reverberating1953205reverberating
secreting1279825__secre__ting
segmenting1445005__segme_nting
segregant1144365__segrega__nt
segregate1145075__segregat__e
segregated1344525__segregat_ed
segregates1245335__segregat_es
serenading1246105__se_renading
seriating10916405__se_r_iating
serrating10513215__se_r_rating
subrogating15164985__subrogating
surrogating13194325__surrogating
tesselating1243845tes__selating
undereating1369555unde_re_ating
unsegregated1552555unsegregat_ed
vegetating1545705__veg_etating
venerating14410055vene_r__ating

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901548.53314624.4
3Display Results1541540.0931655.9
 (SQL Overall)1786911549.01619819.3
 
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.