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

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

79 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
reconstitutions1763271reconstitutions_
reconstitution1663562reconstitution__
constitutions1554863__constitutions_
reconstituting1763233reconstituti_n_g
constitution1455264__constitution__
constitutional1663094__constitutional
reconstitutes1553624reconstitut__es_
reconstructions19124734reconstructions_
restitutions1275704re___stitutions_
constipations1747685__constipations_
constituting1554655__constituti_n_g
constitutionals1761875__constitutionals
deconstructions20124365deconstructions_
destitutions1385255de___stitutions_
institutions1244735___institutions_
prostitutions1554255_pro_stitutions_
reconditions1546825recon_di__tions_
reconsecrations1995105reconsecrations_
reconstitute1453895reconstitut____e
reconstituted1653455reconstitut___ed
reconstruction1894775reconstruction__
reconvictions2054875recon_vi_ctions_
reinstituting1453075re_instituti_n_g
remonetizations2655775remonetizations_
remonstrations16116485remonst_rations_
restitution1175975re___stitution__
consecutions1647056__cons_ecutions_
conspirations1747726__conspirations_
constipation1648566__constipation__
constitutes1376166__constitut__es_
constitutive1754106__constituti__ve
constitutively2262296__constitutively
constrictions1747786__constrictions_
constructions1747716__constructions_
consultations1546936__consultations_
continuations1547146__con_tinuations_
contributions1754746__contributions_
deconditions1645286decon_di__tions_
deconsecrations2064516deconsecrations_
deconstruction19134436deconstruction__
decortications1966776deco_rtications_
demonetizations2755716demonetizations_
demonstrations1795676demonst_rations_
destitution1255546de___stitution__
institution1145296___institution__
institutional1353506___institutional
necessitations16122796nec_essitations_
preconditions1854896precon_di__tions_
preconvictions2353356precon_vi_ctions_
prostitution1454606_pro_stitution__
recanalizations2657466recanalizations_
recantations1448876recan___tations_
recitations13314206rec____itations_
recodifications23165456recodifications_
recognitions1544856reco_gni__tions_
recolonizations26165766recolonizations_
recombinations2095596reco_mbinations_
recompilations2054956reco_mpilations_
recomputations20104106reco_mputations_
reconceptions1965126recon__ceptions_
reconciliations1953746reconciliations_
recondition1447126recon_di__tion__
reconditioned1783276recon_di__tioned
reconfirmations2283086reconfirmations_
reconnections1765756recon__nections_
reconsecration1885566reconsecration__
reconstructing1974436reconstructi_n_g
reconstructors1863936reconst_ructors_
reconviction1955086recon_vi_ction__
redistributions18223406re_distributions_
reinstitutes1253266re_institut__es_
remonetization2555886remonetization__
remonstration15117126remonst_ration__
remotivations1846696remo__tivations_
repositions131110166repo_s_i__tions_
repristinations17193926repristinations_
restituting12156566re___stituti_n_g
resuscitations1673786re_suscitations_
substitutions1553286__substitutions_

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.313570897.8
2DLD Change Limit65874794.70314006.8
3Display Results79790.0461717.4
 (SQL Overall)178691795.06235300.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.