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

144 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
preterminations195429(None) 
pretermination1854771pretermination_
determinations1766892_determinations
determination1657643_determination_
exterminations2365123_exterminations
predestinations1865003predestinations
predominations19105543pre_dominations
prenominations18105763pre_nominations
preordinations1765703pre_ordinations
pretermissions1861883pretermi_ssions
terminations14149753___terminations
codetermination2062124codetermination_
determinatives2052934_determinatives
determinators1653894_determinat_ors
eternizations2258064__eternizations
extermination2275744_extermination_
fraternizations27153744fraternizations
germinations15137944___germinations
indetermination1863134indetermination_
peregrinations17114684p_eregrinations
predestination1765484predestination_
predomination1896534pre_domination_
preformations2045694preform__ations
premeditations1955014preme_ditations
prenomination17126754pre_nomination_
preordination1656154pre_ordination_
preservations1895544preser__vations
pretermission1762114pretermi_ssion_
pretermitting1852554pretermi_tti_ng
prettifications22135184prettifications
prevarications2154734prevar_ications
recriminations1856724_recriminations
redetermination18102294redetermination_
reexaminations23153414_reexaminations
renominations15108304_re_nominations
termination131311164___termination_
alternations1246775_alter__nations
bacterizations2766655bacter_izations
brominations1646745br___ominations
cauterizations25197145cauter_izations
contaminations1886105cont_aminations
criminations1648065cr___iminations
deaminations151010135___deaminations
delaminations1647945_de_laminations
denominations16117855_de_nominations
deteriorations15164685_deteriorations
determinacies1853195_determinaci_es
determinative1954075_determinati_ve
determinator1554575_determinat_o_r
disseminations1755075disse_minations
eliminations1447615__e_liminations
emarginations1674155__emarginations
energizations2356185__energizations
eternization2158665__eternization_
etherizations2557235__ether_izations
examinations2167465__e_xaminations
exercitations2254555__exercitations
exterminating2373855_exterminati_ng
exterminators2252965_exterminat_ors
foreordinations19102065fore_ordinations
fraternization26174055fraternization_
geminations14139255___ge_minations
germination14148975___germination_
inseminations1546235_inse_minations
interlineations1554545_interlineations
itemizations2347825__ite_mizations
laterizations22410065_later_izations
mercerizations2756095mercer_izations
metrications1649825_met_r_ications
nonterminating1773125nonterminati_ng
pasteurizations2673985pasteurizations
patinations13411005p_at___inations
pectinations1649255p___ectinations
peregrination16125205p_eregrination_
perennations1447235p___erennations
permeations1549865p___erm_eations
permutations1646505p___ermutations
personations1448385p___ersonations
perturbations17123255pertur__bations
petrifactions2083555p_et_r_ifactions
petrifications2148025p_etrifications
picturizations2764675pictur_izations
potentiations1555165p_otenti_ations
precipitations2085395pre_cipitations
predestinarians1881945predestinarians
predestinating1854275predestinati_ng
predestinators1762505predestinat_ors
predications17411175pr__e_dications
predominating1964345pre_dominati_ng
preemptions17134845pre_e_m__ptions
prefabrications2492435prefabrications
preformation1946475preform__ation_
prelibations16127625pr__e_libations
premeditation1855705preme_ditation_
premonitions1646855pr__e_monitions
premunitions1644985pr__e_munitions
prenominating1854695pre_nominati_ng
preparations1648305prepar___ations
prepublications2372665prepublications
prescriptions19135325prescr_i_ptions
presentations1548135prese__ntations
preservation1776285preser__vation_
pressurizations2692715pressurizations
pretensions1347075prete___n_sions
pretentious13125585prete___n_tious
preterminal1554575pretermina____l
pretermits1445035pretermi__t___s
prettification21115715prettification_
prevarication2055245prevar_ication_
preventions1648525preve___n_tions
protestations1555805prote__stations
protonations1449055prot___onations
pulverizations28104495pulver_izations
racemizations2665465_race_mizations
ratiocinations1674135_ratiocinations
recombinations2095585_recombinations
recrimination1757405_recrimination_
rededications1746115_rede_dications
redefinitions1752335_rede_finitions
reexamination22153665_reexamination_
reformations1747595_reform__ations
reformulations1953555_reformulations
regurgitations16133145_regurgitations
reiterations12410865_reiter___ations
remediations1548275_reme_di_ations
renomination1499185_re_nomination_
reservations1588585_reser__vations
retaliations12511405_ret_ali_ations
retardations1396515_retar__dations
retentions101611105_rete___n_tions
retributions14134945_ret_r_ibutions
revaccinations2153615_revaccinations
reverberations19113575_reverberations
ruminations1349395_r___uminations
systemizations2864065syste_mizations
terminating1447345___terminati_ng
terminational1553485___terminational
terminators1346035___terminat_ors
transaminations17113425transaminations
trephinations1853555tr__ephinations
veterinarians1662795_veter_inarians
westernisations18172425westernisations
westernizations27154115westernizations
winterizations26157495winter_izations

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.0931921408.6
2DLD Change Limit658741444.76613821.7
3Display Results1441440.1231170.7
 (SQL Overall)1786911444.98235867.3
 
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.