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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
predestinations1865001predestinations_
predestination1765482predestination__
predestinarians1881943predestinarians_
predestinating1854273predestinati_n_g
predestinators1762503predestinat_ors_
destinations13412664___destinations_
predestinarian1772324predestinarian__
predestinates1694634predestinat__es_
predestinator1662984predestinat_o__r
predominations19105544pred_ominations_
preterminations1954304preterminations_
destination12413845___destination__
overestimations20124605overestimations_
pectinations1649255p___ectinations_
peregrinations17114685p_eregrinations_
predesignating1962555predesignati_n_g
predestinate1595045predestinat____e
predestinated1794195predestinat___ed
predestining1654465predestin__i_n_g
predications17411185pred___ications_
predomination1896535pred_omination__
premeditations1955015preme_ditations_
prenominations18105765pre_nominations_
preordinations1765715pre_ordinations_
presentations1548135present__ations_
pretermination1854775pretermination__
protestations1555815protest__ations_
rededications1746125_rede_dications_
redefinitions1752335_rede_finitions_
redistillations1672915_redistillations_
repristinations17193925_repristinations_
aestivations1547486___aestivations_
deaminations151010136___deaminations_
declinations15410226___declinations_
desalinations14410186___desalinations_
designations1456946___designations_
destitutions1385256___destitutions_
determinations1766896_determinations_
detestations1347586_detest__ations_
detonations1239376___de_tonations_
distinctions1557326___distinctions_
domestications19143996_domestications_
estimations1349946____estimations_
estivations1449276____estivations_
fenestrations1695406_fenest_rations_
investigations1853726_investigations_
misestimations18144426_misestimations_
necessitations16122796_necessitations_
orchestrations19113306orchest_rations_
ordinations1247996or_d___inations_
overestimation19125146overestimation__
palletizations25105016palle_tizations_
patinations13411006p____atinations_
pectination15410336p___ectination__
pelletizations25105036p_elletizations_
penetrations1448856p_ene_t_rations_
peregrination16125206p_eregrination__
perennations1447256p_ere__nnations_
perpetrations1746376perpe_t_rations_
perpetuations1754986perpe_t_uations_
personations1448396p_e_rs_onations_
perspirations1786176p_e_rspirations_
potentiations1555186p_otenti_ations_
preadaptations1951756preadapt__ations_
precipitations2085396pre_cipitations_
predations13812156pred_____ations_
predesignates1762636predesignat__es_
predestines1446996predestin____es_
predevaluation2062386predevaluation__
predication16412436pred___ication__
predictions1649656pred___i_ctions_
predispositions2092086predispositions_
predominating1964346pred_ominati_n_g
prefabrications2492436prefabrications_
prelibations16127626pr__e_libations_
premeditation1855706preme_ditation__
prenomination17126756pre_nomination__
preordination1656156pre_ordination__
prepositions16108306prepos_i__tions_
prepublications2372666prepublications_
presentation1448996present__ation__
presentational1673216present__ational
preservations1895546pr__eservations_
pressurizations2692716pressurizations_
prettifications22135186prettifications_
prevarications2154746pre_varications_
preventions1648536preve___n_tions_
prioritizations26123856prioritizations_
privatizations2855176pr_ivatizations_
procrastination1962456procrastination__
progestational1762756progest__ational
propitiations1756206pr_opiti_ations_
prostitutions1554256pr__ostitutions_
prostrations1449766pr__ost_rations_
protestation1456366protest__ation__
protonations1449076pr___otonations_
reactivations18176146_re_activations_
recombinations2095596_recombinations_
recriminations1856726_recriminations_
redecorations1645086_rede_corations_
rededication1646506_rede_dication__
redefinition1652526_rede_finition__
redescriptions1962786_redescriptions_
redistillation1563036_redistillation__
redistributions18223406_redistributions_
reduplications1964536_reduplications_
reescalations1573786_re_escalations_
reestimating1545936_re_estimati_n_g
reexaminations23153416_reexaminations_
registrations1446896_regist_rations_
remediations1548276_reme_di_ations_
remotivations1846696_re_motivations_
renegotiations15113376_renegoti_ations_
renominations15108306_re_nominations_
repetitions1378026_repe_ti__tions_
repristination16204106_repristination__
resignations1346886_r__esignations_
respirations14410306_r__espirations_
restations10315846_r__est__ations_
restitutions1275706_r__estitutions_
restorations12410956_r__estorations_
resuscitations1673786_resuscitations_
revaccinations2153616_revaccinations_
rustications1448566_r__ustications_
trephinations1853556tr__ephinations_

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 Limit658741255.28312469.1
3Display Results1251250.0931344.1
 (SQL Overall)1786911255.68931409.9
 
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.