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

155 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
resegregations165369(None) 
desegregations1763551desegregations
resegregation1563901resegregation_
desegregation1663812desegregation_
reaggregations1762842reaggregations
resegregating1652842resegregati_ng
segregations1445802__segregations
desegregating1752733desegregati_ng
nonsegregations17162683nonsegregations
reaggregation1653143reaggregation_
resegregates1452783resegregat__es
reservations1588583rese_r_vations
revegetations17114713reveg_etations
segregation1346383__segregation_
aggregations1553844__aggregations
congregations17186394_congregations
desecrations1559184desecr__ations
desegregates1552934desegregat__es
disaggregations1962504disaggregations
nonsegregation16132794nonsegregation_
peregrinations17114684peregrinations
preservations1895544prese_r_vations
reaggregating1552564reaggregati_ng
recreations13412234r__ecre_ations
regenerations1447134rege_nerations
relegations1248974r__e_legations
remigrations15227794remigr__ations
renegotiations15113374renegotiations
reregulations1455704rereg_ulations
resegregate1352974resegregat___e
resegregated1552804resegregat__ed
reservation1489144rese_r_vation_
resignations1346874resig__nations
respirations14410304respir__ations
restorations12410934restor__ations
resurrections1553454resurre_ctions
revegetation16105304reveg_etation_
reverberations19113564reverberations
segregating1445444__segregati_ng
segregationist1692904__segregationist
aggregation1454255__aggregation_
antisegregation1771905antisegregation_
asseverations1652595asse_verations
celebrations1645735celebr__ations
cerebrations1646935cerebr__ations
congregation16226765_congregation_
deaerations12311665deae_r__ations
decelerations1646405dece_lerations
decerebrations1993725dece_rebrations
degenerations1546335dege_nerations
degradations1544555__degradations
delegations1348035__de_legations
denegations1348545__de_negations
denervations1657095dene_r_vations
denigrations1447355denigr__ations
deprecations1748535__deprecations
depredations1646725__depredations
deregulations1545195dereg_ulations
derogations1349385__de_rogations
desecration14410065desecr__ation_
desegregate1453015desegregat___e
desegregated1652805desegregat__ed
desertions1139885dese_r___tions
desiderations1545655des_iderations
designations1456935desig__nations
desperations1559495des__perations
disaggregation1862695disaggregation_
disrelations1348485dis__relations
emigrations14187155_emigr__ations
energizations2356185_energizations
enervations1478575_ene_r_vations
exaggerations2253485_exaggerations
execrations2048905_execr__ations
exenterations2054475_exenterations
expurgations2274125_expur_gations
federations1548865fede_r__ations
generations12311405gene_r__ations
integrations13129475integr__ations
interrelations1457615interrelations
interrogations1556815interrogations
miscegenations1963015misceg_enations
miscreations1647045mis_cre_ations
observations1785015obse_r_vations
penetrations1448845penetr__ations
peregrination16125205peregrination_
perseverations1953225perse_verations
preselections17144435prese_le_ctions
presentations1548125prese__ntations
preservation1776285prese_r_vation_
pressurizations2692715pressurizations
reaggregates1593125reaggregat__es
reannexations2052835re_annexations
reciprocations20203385reciprocations
recordations1548625re_cor_dations
recreation12413615r__ecre_ation_
recuperations1746075re_cuperations
redecorations1645055rede_corations
rededications1746115rede_dications
redigestions1483865redig_e_stions
redintegrations17143255redintegrations
redirections1546145re_dire_ctions
reeducations1545465re_e_ducations
reelections13167945re_e_le_ctions
reescalations1573785re_escalations
reevaluations1654275re_evaluations
reforestations1754445re_forestations
reformations1747595re_for_mations
refrigerations1863775refrigerations
regeneration1348195rege_neration_
regressions1247095r__egre_ssions
regulations12310715r__eg_ulations
regurgitations16133145regurgitations
rehydrations1943985rehydr__ations
reinnervations1753445reinnervations
reintegrations15164785re_integrations
reiterations12410855r__eiterations
rejuvenations23122695re_juvenations
relegation11610025r__e_legation_
relubrications1854195relubrications
remediations1548275reme__diations
remigration14228915remigr__ation_
remunerations1556195re_munerations
renegotiation14113665renegotiation_
reoperations14410045r__eoperations
reparations13611655re_par__ations
repatriations15136515repatr_iations
reprobations1647775r__eprobations
reregistrations1672825reregistrations
reregulation1346415rereg_ulation_
resections121513025res___e_ctions
reservationist17114325rese_r_vationist
resignation1247475resig__nation_
resorptions1347215res_or__ptions
respiration13511195respir__ation_
restations10315835res____tations
restimulations1654645restimulations
restoration11412095restor__ation_
restrictions1449275res_tr_ictions
resurrection1453355resurre_ction_
resuscitations1673785resuscitations
retardations1396515re_tar_dations
retrogradations17151645retrogradations
revegetating1753685reveg_etati_ng
revelations14410305r__e_velations
reverberation1893875reverberation_
secretions12117845__secre__tions
segmentations1655585__segmentations
segregates1245325__segregat__es
segregationists17122295__segregationists
segregative1654065__segregati_ve
seriations10316675__se_r_iations
serrations10313055__se_r_rations
subrogations1545455__subrogations
vegetations1547315__veg_etations
venerations14411285vene_r__ations

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 Filter178691950240.1231452772.4
2DLD Change Limit950241557.89012043.6
3Display Results1551550.0961614.6
 (SQL Overall)1786911558.10922036.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.