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

161 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
desegregations176356(None) 
desegregation1663811desegregation_
resegregations1653691resegregations
desegregating1752732desegregati_ng
resegregation1563902resegregation_
segregations1445802__segregations
desecrations1559213desecr__ations
desegregates1552933desegregat__es
disaggregations1962513disaggregations
nonsegregations17162693nonsegregations
reaggregations1762843reaggregations
resegregating1652843resegregati_ng
segregation1346383__segregation_
aggregations1553844__aggregations
congregations17186414_congregations
deaerations12311674deae_r__ations
decelerations1646424dece_lerations
decerebrations1993744dece_rebrations
degenerations1546354dege_nerations
degradations1544554d__egradations
delegations1348034d__e_legations
denegations1348544d__e_negations
denervations1657094dene_r_vations
denigrations1447354denigr__ations
deprecations1748564d__eprecations
depredations1646734d__epredations
deregulations1545204dereg_ulations
derogations1349394d__e_rogations
desecration14410074desecr__ation_
desegregate1453014desegregat___e
desegregated1652804desegregat__ed
desertions1139884dese_r___tions
desiderations1545674des_iderations
designations1456944desig__nations
desperations1559524des__perations
disaggregation1862694disaggregation_
disrelations1348504dis__relations
nonsegregation16132804nonsegregation_
peregrinations17114684peregrinations
reaggregation1653144reaggregation_
resegregates1452784resegregat__es
reservations1588584rese_r_vations
revegetations17114714reveg_etations
segregating1445454__segregati_ng
segregationist1692914__segregationist
aggregation1454255__aggregation_
antisegregation1771915antisegregation_
asseverations1652595asse_verations
celebrations1645745celebr__ations
cerebrations1646965cerebr__ations
congregation16226765_congregation_
deaeration11313015deae_r__ation_
debarkations1943655de_bar_kations
deceleration1547175dece_leration_
decerebration1884195dece_rebration_
declarations1546805declar__ations
decorations14312885de_cor__ations
defecations1779005d__e_fecations
defibrinations2053415defibrinations
deflagrations1883025deflagr__ations
deflorations1646065deflor__ations
deforestations1853965de_forestations
deformations1846845de_for_mations
degeneration1447285dege_neration_
degradation1445385d__egradation_
degustations1444835d__egustations
dehydrations2043405dehydr__ations
delectations1547455dele__ctations
delegation1238885d__e_legation_
delegitimations19182445delegitimations
deliberations1645535de_liberations
delineations1346765de_line_ations
demarcations1746125de_mar_cations
denegation1249415d__e_negation_
denervation1567945dene_r_vation_
denigration1348465denigr__ation_
deodorizations2556325deodorizations
deoxygenations2661745deoxygenations
depigmentations21102845depigmentations
deportations1548465de_por_tations
depravations1885375d__epravations
deprecation1648965d__eprecation_
depreciations1846575d__epreciations
depredation1546925d__epredation_
deprivations1897925d__eprivations
derealizations24910815derealizations
deregulation1446085dereg_ulation_
derepressions1653075derepre_ssions
derivations15611495d__e_rivations
derogation12410395d__e_rogation_
desalinations14410185des_alinations
descriptions1755405des_cr_iptions
desecrating1548095desecr__ati_ng
desecrators1445235desecr__at_ors
desertion10410205dese_r___tion_
desiccations1755655des__iccations
desideration1456395des_ideration_
designation1347485desig__nation_
desolations12310595des___olations
desorptions1445995des_or__ptions
desperation14510115des__peration_
despoliations1646395des_poliations
desquamations2581755des_quamations
destinations13412665des__tinations
destructions1547255des_tr_uctions
deteriorations15164695deteriorations
determinations1766895determinations
detestations1347585dete__stations
deuterations1348085d__euterations
dieselizations2455915diese_lizations
dimerizations2548545dime_rizations
disaggregating1762155disaggregati_ng
discretions1447225dis_cre__tions
disintegrations17153635disintegrations
disrelation1248815dis__relation_
dissertations1465895disser_tations
emigrations14187155_emigr__ations
energizations2356185_energizations
enervations1478575_ene_r_vations
exaggerations2253485_exaggerations
execrations2048925_execr__ations
exenterations2054485_exenterations
expurgations2274125_expur_gations
federations1548885fede_r__ations
generations12311425gene_r__ations
integrations13129475integr__ations
interrelations1457615interrelations
interrogations1556815interrogations
miscegenations1963025misceg_enations
miscreations1647065mis_cre_ations
observations1785015obse_r_vations
penetrations1448855penetr__ations
peregrination16125205peregrination_
perseverations1953245perse_verations
preservations1895545prese_r_vations
reaggregating1552565reaggregati_ng
recreations13412255__recre_ations
regenerations1447145rege_nerations
relegations1248975__re_legations
remigrations15227795remigr__ations
renegotiations15113375renegotiations
reregulations1455715rereg_ulations
resegregate1352975resegregat___e
resegregated1552805resegregat__ed
reservation1489145rese_r_vation_
resignations1346885resig__nations
respirations14410305respir__ations
restorations12410955restor__ations
resurrections1553465resurre_ctions
revegetation16105305reveg_etation_
reverberations19113585reverberations
secretions12117855__secre__tions
segmentations1655595__segmentations
segregates1245335__segregat__es
segregationists17122295__segregationists
segregative1654065__segregati_ve
seriations10316685__se_r_iations
serrations10313105__se_r_rations
subrogations1545455__subrogations
vegetations1547325__veg_etations
venerations14411315vene_r__ations

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 Filter178691950240.356501941.0
2DLD Change Limit950241617.48612693.6
3Display Results1611610.1101463.6
 (SQL Overall)1786911617.95222471.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.