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

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

103 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
redintegrations17143251redintegrations_
redintegration16153642redintegration__
reintegrations15164782re_integrations_
redintegrating1763113redintegrati_n_g
reintegration14175373re_integration__
disintegrations17153634disintegrations_
integrations13129474___integrations_
redintegrates1563094redintegrat__es_
redintegrative1962184redintegrati__ve
reintegrating1554614re_integrati_n_g
reiterations12410874re_i_te_rations_
disintegration16123785disintegration__
exenterations2054485_exente_rations_
integration121310495___integration__
integrationist1583685___integrationist
reconsecrations1995105reconsecrations_
redintegrate1463185redintegrat____e
redintegrated1662885redintegrat___ed
redistillations1672925redistillations_
regenerations1447145regen_e_rations_
registrations1446905regist__rations_
reinfestations1793885re_infestations_
reinnervations1753445re_innervations_
reinsertions1245285re_inse_r_tions_
reintegrates1374945re_integrat__es_
reintegrative17103255re_integrati__ve
reinvigorations19152415re_invigorations_
reiteration11412175re_i_te_ration__
remigrations15227795remi___grations_
remunerations1556205remun_e_rations_
adulterations1453176_adulte_rations_
alliterations1384556alli_te_rations_
deconsecrations2064516deconsecrations_
degenerations1546356degen_e_rations_
deliberations1645536deli_be_rations_
delineations1346766delin_e__ations_
denegations1348546__den_eg_ations_
denigrations1447356__den_igrations_
desiderations1545676desi_de_rations_
deuterations1348086__deute_rations_
disintegrating1763306disintegrati_n_g
disintegrators1691756disintegrat_ors_
emigrations14187156_emi___grations_
eviscerations1882706_evisce_rations_
exenteration1955306_exente_ration__
exonerations1947016_exon_e_rations_
federations1548886fed___e_rations_
generations12311426ge__n_e_rations_
incinerations1545686incin_e_rations_
integrating1349496___integrati_n_g
integrationists1682576___integrationists
integrators1246526___integrat_ors_
intenerations1347466___intenerations_
interactions14410466___inte_ractions_
iterations10413826___i_te_rations_
itinerations1245686_itin_e_rations_
literations11610586__li_te_rations_
meditations1449336medi_t___ations_
obliterations1553456obli_te_rations_
penetrations1448856pe__n_etrations_
preponderations20112876preponde_rations_
reaggregations1762846reaggreg_ations_
reannexations2052836re_anne_xations_
recantations1448876recant___ations_
recitations13314206reci_t___ations_
reconsecration1885566reconsecration__
recuperations1746086re_cupe_rations_
redecorations1645086red__ecorations_
redigestions1483876redi___gestions_
redirections1546186redi_re__ctions_
redistillation1563036redistillation__
redistributions18223416redistributions_
refrigerations1863776refrige_rations_
regeneration1348196regen_e_ration__
regimentations1784856regi_mentations_
registration1347546regist__ration__
reincarnations1672786re_incarnations_
reinfections1745326re_infe__ctions_
reinfestation1664256re_infestation__
reinflations1546646re_in__flations_
reinjections2144406re_inje__ctions_
reinnervation1653626re_innervation__
reinoculations1653926re_inoculations_
reinsertion1145446re_inse_r_tion__
reinstallations1562156re_installations_
reintegrate1274956re_integrat____e
reintegrated1474496re_integrat___ed
reinventions1554216re_inve__ntions_
reinvigoration18152716re_invigoration__
reiterating12410506re_i_te_rati_n_g
relegations1248976re___leg_ations_
remigration14228916remi___gration__
remonetizations2655776remonetizations_
remonstrations16116496remon_strations_
remuneration1446936remun_e_ration__
renaturations1355966re__naturations_
reoperations14410066re__ope_rations_
resegregations1653696resegreg_ations_
resignations1346886resi___gnations_
restorations12410966re__st_orations_
reverberations19113586reverbe_rations_
sedimentations1754416sedi_mentations_
venerations14411316ve__n_e_rations_

Search took 6 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 Filter178691658740.326548131.9
2DLD Change Limit658741034.68614057.6
3Display Results1031030.0801287.5
 (SQL Overall)1786911035.09235092.5
 
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.