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

145 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
preconvictions235335(None) 
preconviction2253701preconviction_
reconvictions2054871_reconvictions
preconditions1854892precondi_tions
reconviction1955082_reconviction_
convictions1848043___convictions
precognitions1853593precogni_tions
preconceptions2253883preconceptions
precondition1755243precondi_tion_
preconvention2074003preconvention_
premonitions1646853premon_i_tions
reconditions1546823_recondi_tions
reconnections1765753_reconnections
reconvicting20114623_reconvicti_ng
convections18411494___convections
conviction1748184___conviction_
deconditions1645284_decondi_tions
precognition1753884precogni_tion_
precombustions2262054precombustions
preconception2154284preconception_
preconditioned2062414precondi_tioned
preconscious1852904precon_sc_ious
predictions1649654pre___dictions
preignitions1554004preign_i_tions
premonition1547354premon_i_tion_
premunitions1644984premun_i_tions
prepositions16108304prepo_si_tions
recognitions1544854_recogni_tions
recollections1754724_recollections
reconceptions1965124_reconceptions
recondition1447124_recondi_tion_
reconnection1655994_reconnection_
reconversions1853864_reconversions
reconvicts1744384_reconvict___s
brecciations1844285brec__ciations
concoctions1448255___concoctions
conditions13410105___condi_tions
conductions1649665___conductions
confections18411395___confections
conflictions1945225___conflictions
connections15410705___connections
conniptions1546035___conniptions
convection17411125___convection_
conventions16410535___conventions
convicting1847585___convicti_ng
convocations1947365___convocations
decoctions1547145_deco___ctions
decondition1545415_decondi_tion_
decongestions1753565_decongestions
decortications1966775_decortications
disconnections1954025disconnections
evictions14228625__e___victions
misconnections2063815misconnections
nonconnections1894145nonconnections
nonfictions1645935___nonfictions
percolations1648055perco__lations
personations1448395person__ations
precautions1546555prec___autions
precipitations2085395precipitations
precipitins1746175prec_ipi_ti_ns
precisions1449375prec___i_sions
precocious1644745preco___c_ious
precocities1748165preco_ci_ti_es
precombustion2162245precombustion_
preconceives2152795precon__ceives
preconcerting2084415preconcerti_ng
preconditioning2161805precondi_tioning
preconizing2548235precon_i_zi_ng
predications17411185pre___dications
prediction15410305pre___diction_
predilections1853565pre_dilections
predominations19105545predominations
prefabrications2492435prefabrications
preformations2045715prefo_rmations
preignition1454435preign_i_tion_
preinduction1753785pre_induction_
preinviting1744365pre_invi_ti_ng
prelections151210475pre___lections
premunition1545575premun_i_tion_
prenominations18105765prenominations
prenotions1248295pre__n__otions
preoccupations2252015preoccupations
preoptions1447645pre_o___ptions
preordinations1765715pre_ordinations
preponderations20112875preponderations
preportions1548265prepo___rtions
preposition15108585prepo_si_tion_
preproductions2153945preproductions
prepublications2372665prepublications
prescriptions19135335pre_scriptions
preselections17144445pre_selections
presentations1548135presen_tations
preservations1895545preserv_ations
prettifications22135185prettifications
prevarications2154745pre_varications
preventions1648535pre___ventions
previsions1547735pre___vi_sions
proactions1449345pr__o__actions
productions1647535pr__o_ductions
projections2258475pr__o_jections
prolongations1673355prolon_gations
pronations12314035pr__on__ations
pronunciations18122785pronunciations
propositions16108315propo_si_tions
protections15510705pr__o_tections
protonations1449075proton__ations
protractions1646645pr__otractions
provisions1547215pr__o_vi_sions
provocations1956875pr__o_vocations
recantations1448875_recan_tations
recodifications23165455_recodifications
recognition1445205_recogni_tion_
recollection1654855_recollection_
recombinations2095595_recombinations
recommissions1953655_recommissions
recompilations2054955_recompilations
reconception1855645_reconception_
reconciliations1953745_reconciliations
reconditioned1783275_recondi_tioned
reconducting1854725_reconducti_ng
reconfirmations2283085_reconfirmations
reconnecting1745355_reconnecti_ng
reconsecrations1995105_reconsecrations
reconstitutions1763275_reconstitutions
reconstructions19124735_reconstructions
recontacting1745065_recontacti_ng
reconversion1754025_reconversion_
reconverting1876405_reconverti_ng
reconvict1646085_reconvict____
reconvicted1944275_reconvict__ed
reconvincing2053165_reconvinci_ng
recordations1548645_reco_rdations
rectifications2148915_rectifications
reignitions1244555_reign_i_tions
reinfections1745325_re_infections
reinjections2144405_re_injections
reinventions1554215_re_inventions
relictions12310025_re___lictions
remotivations1846695_remotivations
renditions1149185_re__ndi_tions
renovations1448425_reno_v_ations
renunciations1554855_renunciations
repositions131110165_repo_si_tions
restrictions1449285_re_strictions
retrodictions1655535_retrodictions

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.360496363.9
2DLD Change Limit950241456.29615092.8
3Display Results1451450.1101318.2
 (SQL Overall)1786911456.76626410.1
 
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.