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

104 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
preproductions215394(None) 
preproduction2054391preproduction_
reproductions1865271_reproductions
reproduction1765652_reproduction_
coproductions2054493_coproductions
overproductions2363773overproductions
postproductions2272493postproductions
productions1647523___productions
reproductives21113293_reproductives
retrodictions1655533_retrodictions
coproduction1954744_coproduction_
hyperproduction2872534hyperproduction_
introductions1655134_introductions
overproduction2264054overproduction_
postproduction2162894postproduction_
predictions1649644pre___dictions
preinduction1753784pre_induction_
preportions1548244prep_o__rtions
prepositions16108294prep_o_sitions
production1547894___production_
reductions1359584_re___ductions
reintroductions1862154_reintroductions
reprobations1647774_repro_bations
reproducing1744524_reproduc_i_ng
reproductive20124334_reproducti_ve
retroactions1447064_retro_actions
retrodiction1555654_retrodiction_
deductions1467125_de___ductions
depredations1646735_depred_ations
eductions1268775__e___ductions
introduction1555785_introduction_
liposuctions1662035_lip_osuctions
overeducations2054975ove_reducations
overprotections2263335overprotections
perditions1348875p_e_r_d_itions
perfections1848125p_e_r_fections
perorations13314045p_e_ro_rations
perpetuations1754975perp_etuations
persecutions1654775p_e_rsecutions
petrifactions2083555p_etrifactions
photoproduction2573055photoproduction_
photoreductions23153335photoreductions
precautions1546545pre__cau_tions
precognitions1853595pre_cognitions
precombustions2262045precombustions
preconditions1854895pre_conditions
preconvictions2353355preconvictions
predations13812145pre___d_ations
prededucting1952545pre_deducti_ng
predications17411175pre___dications
prediction15410305pre___diction_
predilections1853545pre_dilections
preformations2045695pre_formations
prelections151210455pre___lections
premonitions1646855pre_mo_nitions
prenotions1248285pre_no___tions
preoptions1447635pre__o__ptions
preordinations1765705preordinations
preparations1648305prep__arations
preponderations20112865preponderations
preportion1448875prep_o__rtion_
preposition15108575prep_o_sition_
prepublications2372665prepublications
preselections17144435pre_selections
proactions1449335___pro_actions
productional1794705___productional
projections2258465___projections
proportions1548455prop_o__rtions
propositions16108305prop_o_sitions
proprioceptions2091795proprioceptions
prorogations1556705pr_oro_gations
protections15510695___protections
protractions1646635protr__actions
recordations1548635_record_ations
redactions1359135_re___dactions
reduction1259905_re___duction_
reeducations1545465_re__educations
refractions16127725_refr__actions
reintroduction1762375_reintroduction_
repopulations1765325_rep_opulations
repositions131110155_rep_o_sitions
reprobation1548505_repro_bation_
reproducers1653325_reproduc__ers
reproduces1544935_reproduc___es
reproducible19132585_reproduc_ible
reproducibles20131755_reproducibles
reproducibly22122315_reproduc_ibly
reproductively2562505_reproductively
reprovisions1753765_repro_visions
repudiations1597035_rep_udiations
reradiations1349495_re_radiations
resolutions11117795_re_solu_tions
retractions13910345_retr__actions
retributions14134945_retribu_tions
retroaction1347365_retro_action_
retrodicting1654465_retrodicti_ng
retroflections1953855_retroflections
retrospections1894165_retrospections
revolutions1497635_re_volu_tions
seductions1366875_se___ductions
superinductions2063705superinductions
transductions1664295tr_ansductions
trepidations1554935trep_id_ations
underproduction2171985underproduction_

Search took 7 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.1261418182.5
2DLD Change Limit950241046.11015552.2
3Display Results1041040.0631650.8
 (SQL Overall)1786911046.29928368.2
 
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.