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

114 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
reconstituted165345(None) 
reconstitute1453891reconstitute_
reconstitutes1553621reconstitutes
constituted1475052__constituted
reinstituted1353122re_instituted
constitute1276703__constitute_
constitutes1376163__constitutes
reconstituting1763233reconstituting
reconstitution1663563reconstitution
reconstructed1854263reconstructed
reinstitute1153603re_institute_
reinstitutes1253263re_institutes
restituted1156533re___stituted
constipated1645464__constipated
deconstructed1953704deconstructed
destituted1255254de___stituted
instituted1144944___instituted
preconstructed21102714preconstructed
prostituted1454004_pro_stituted
recommitted1853884reco_mmit_ted
reconfigured1951944recon_figured
reconnoitered1661494reconnoitered
reconnoitred1562004reconnoit_red
reconsecrated1884394reconsecrated
reconsidered1652304recons_idered
reconsigned1553504recons_i_gned
reconsolidated18132134reconsolidated
reconstitutions1763274reconstitutions
reconsulted1454244recons__ulted
recontacted1654714recon_t_acted
recontoured1453234recon_t_oured
reconvicted1944274recon_vi_cted
remonstrated15145574remonst_rated
restitute947754re___stitute_
restitutes1057834re___stitutes
consisted1238505__cons_i_sted
constipate1446395__constipate_
constipates1546355__constipates
constituent1394945__constituent
constituting1554655__constituting
constitution1455265__constitution
constitutive1754105__constitutive
constricted1646365__constricted
constructed1646255__constructed
construed1247315__const_ru_ed
continued1248485__con_tinu_ed
contributed1654265__contributed
deconsecrated19113855deconsecrated
decorticated18144165deco_rticated
demonstrated16134895demonst_rated
destitute1046885de___stitute_
destitutes1156525de___stitutes
disubstituted1761175disubstituted
institute946445___institute_
instituter1044515___instituter
institutes1046055___institutes
necessitated1552255nec_essitated
preconsciouses2061745preconsciouses
prostitute1255195_pro_stitute_
prostitutes1345175_pro_stitutes
recentrifuged2091385recentrifuged
recomputed1744725reco___mputed
reconceived1953785reconcei__ved
reconcentrated1983345reconcentrated
reconciled1545465recon_ci__led
recondite1248965recon_di__te_
reconditioned1783275reconditioned
reconducted1744285recon__ducted
reconfigure1752285recon_figure_
reconfigures1852195recon_figures
reconfined1645685recon_fi__ned
reconfirmed1952975recon_fi_rmed
reconnected1665105recon__nected
reconnoiter1373005reconnoi__ter
reconnoitre1362315reconnoit_re_
reconnoitres1452325reconnoit_res
reconsecrate1694755reconsecrate_
reconsecrates1784425reconsecrates
reconsider1344535recons_i__der
reconsoled1344555recons___oled
reconsolidate16122295reconsolidate_
reconsolidates17122225reconsolidates
reconstruct1554905reconst_ru_ct
reconstructor1764095reconstructor
reconstructs1654245reconst_ructs
recontaminated19122925recontaminated
reconverted1745655recon__verted
reconvinced1953805recon_vi_nced
rectitude1244775rec___titude_
rectitudes1344795rec___titudes
recultivated1853115rec_ultivated
redistributed17122675re_distributed
reestimated1445955re__estimated
reinitiated1245205re_initi_ated
reinstated1147285re_ins__tated
reinstituting1453075re_instituting
reknitted1444025re_kn__it_ted
remonetized2354115remoneti__zed
remonstrate13146405remonst_rate_
remonstrates14146055remonst_rates
remotivated1744145remo__tivated
reoutfitted1551485re_outfit_ted
reposited1239135repo_s_i__ted
repristinated1672545repristinated
resensitized2253945resens_itized
resituated1147325re___s_ituated
restitched1644135re___stitched
resuscitated1552565re_suscitated
retransmitted1671655retransmit_ted
substituted1453445__substituted
trisubstituted177575trisubstituted
unconstricted1853365unconstricted
unconstructed1853925unconstructed
unreconstructed2081735unreconstructed

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.1561145455.1
2DLD Change Limit1247901149.29613424.1
3Display Results1141140.0601900.0
 (SQL Overall)1786911149.51218785.8
 
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.