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

280 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
peregrinations1711468(None) 
peregrination16125201peregrination_
peregrinating1752972peregrinati_ng
peregrinates1553343peregrinat__es
perennations1447223pere__nnations
preordinations1765693p_reordinations
cerebrations1646934cerebr__ations
defibrinations2053404defibrinations
deracinations1647814der_acinations
derealizations24910804derealizations
deregulations1545194dereg_ulations
desegregations1763554desegregations
determinations1766884determinations
emarginations1674154_emarginations
energizations2356184_energizations
evaginations1645824_evag_inations
foreordinations19102064foreordinations
germinations15137944ger__minations
marginations1546454mar_g_inations
mercerizations2756084mercerizations
originations13106164_orig_inations
paginations1447754p__ag_inations
pectinations1649254p__ectinations
penetrations1448844penetr__ations
peregrinate1454034peregrinat___e
peregrinated1653084peregrinat__ed
perennation1348084pere__nnation_
perforations1747844perfor__ations
periodizations2655574periodizations
perorations13314034per_or__ations
perpetrations1746354perpetr__ations
personations1448384per__sonations
perspirations1786164per_spirations
perturbations17123254pertur_bations
predestinations1865004predestinations
predications17411174p_re_dications
predominations19105544predominations
prelibations16127624p_re_libations
prenominations18105764prenominations
preordination1656154p_reordination_
preterminations1954294preterminations
prevarications2154734prevarications
reregulations1455704rereg_ulations
resegregations1653694resegregations
terminations14149754ter__minations
terrorizations2356164terrorizations
trephinations1853554_trephinations
allegorizations25112895allegorizations
alternations1246775alte_r_nations
appreciations1964735appre_ci_ations
appropriations1763175appropri_ations
arborizations2447405_arborizations
barbarizations27115445barbarizations
brecciations1844275_brecci_ations
brominations1646735_br_ominations
carburizations2754125carburizations
categorizations27103865categorizations
celebrations1645735celebr__ations
cerebration1547905cerebr__ation_
certifications2147795certifications
chlorinations1855505_chlorinations
crenations12511675_cre___nations
creolizations2457885_creolizations
crepitations1647475_cre_pitations
criminations1648065_cr_iminations
curarizations2447475cur_arizations
cybernations1943605cybe_r_nations
deaerations12311665deae_r__ations
deaminations151010125__deaminations
dechlorinations2153105dechlorinations
declinations15410215__declinations
decrepitations1984335decre_pitations
defibrination1953865defibrination_
degradations1544555__degradations
delaminations1647935de_laminations
delegations1348035deleg___ations
delegitimations19182445delegitimations
demyelinations2052765demyelinations
denegations1348545deneg___ations
denervations1657095dene_r_vations
denigrations1447355denigr__ations
denominations16117845de_nominations
deodorizations2556295deodorizations
depreciations1846545depre_ci_ations
deprivations1897915__deprivations
deracination1548865der_acination_
derealization231011525derealization_
deregulation1446085dereg_ulation_
derelictions1544335dere_li_ctions
derivations15611485__de_rivations
derogations1349385derog___ations
desalinations14410175de_salinations
desecrations1559185desecr__ations
desegregation1663815desegregation_
designations1456935desig__nations
destinations13412655__destinations
deteriorations15164675dete_riorations
determination1657645determination_
dimerizations2548525dime_rizations
eliminations1447605_e_liminations
elutriations1246025_elutri_ations
emargination1554865_emargination_
emigrations14187155_emigr__ations
energization2256495_energization_
enervations1478575_ene_r_vations
eradications1549295_er_adications
erotizations21410995_er_otizations
eternizations2258065_eternizations
etherizations2557225_etherizations
evagination1546565_evag_ination_
examinations2167465_e_xaminations
excoriations2147495_excori_ations
execrations2048905_execr__ations
exercitations2254555_exercitations
exterminations2365125exterminations
extrications2149045_e_xtrications
federations1548865fede_r__ations
fertilizations26137895fertilizations
fiberizations27136345fibe_rizations
fluorinations16103955_fluorinations
foreordination1892285foreordination_
geminations14139255__ge_minations
generations12311405gene_r__ations
geometrizations2753415geometrizations
germanizations26166825germanizations
germination14148975ger__mination_
herniations1447405her__ni_ations
hibernations1744045hibe_r_nations
imaginations1546335_imag_inations
impregnations1853765impreg__nations
inebriations1456325_inebri_ations
inseminations1546225inse_minations
integrations13129475integr__ations
invaginations1755085invag_inations
irrigations1246935_ir__rigations
irritations1147825_ir__ritations
laterizations22410055late_rizations
linearizations2355905linearizations
margination1447435mar_g_ination_
marinations13411265___marinations
martyrizations2854475martyrizations
memorizations2649505me_morizations
mercerization2656315mercerization_
mercurations1646535mercur__ations
metrications1649815__metrications
necessitations16122795necessitations
ordinations1247975_or__dinations
origination1267085_orig_ination_
overestimations20124585overestimations
pagination1348995p__ag_ination_
participations2054525participations
parturitions1453775parturi__tions
pasteurizations2673985pasteurizations
patinations13411005p___atinations
pectination15410335p__ectination_
pelletizations25105025pelletizations
penalizations24511625pe_nalizations
penetration1349895penetr__ation_
perambulations2053055perambulations
percolations1648025per__colations
perditions1348865per__di__tions
peregrines1346505peregrin____es
peregrins1246965peregr____i_ns
perennating1445535pere__nnati_ng
perforation1648995perfor__ation_
periodization2556065periodization_
permeations1549865p__e_rmeations
permutations1646505per__mutations
peroration12315995per_or__ation_
perpetration1647125perpetr__ation_
perpetuations1754975per_petuations
perseverations1953225perseverations
personation1349485per__sonation_
perspiration1656835per_spiration_
pertinacious1652805per__tinacious
perturbation16123545pertur_bation_
petrifactions2083555p__etrifactions
petrifications2148025petrifications
picturizations2764665picturizations
polarizations24219695p_olarizations
pollinations1447235p__ollinations
potentiations1555145potenti_ations
precipitations2085395precipitations
precognitions1853595p_recognitions
predations13812145p_re___dations
predestination1765485predestination_
predication16412435p_re_dication_
predictions1649645p_re_di_ctions
predomination1896535predomination_
prefabrications2492435prefabrications
preformations2045695p_reformations
preignitions1554005p_re_ignitions
prelibation15128665p_re_libation_
premeditations1955015premeditations
premonitions1646855p_re_monitions
premunitions1644985p_re_munitions
prenomination17126755prenomination_
prenotions1248285p_re___notions
preparations1648305p_re_parations
preprinting1647415p_reprin_ti_ng
prescriptions19135325prescri_ptions
presentations1548125p_resentations
preservations1895545p_reservations
pressurizations2692715pressurizations
pretermination1854775pretermination_
prevarication2055245prevarication_
preventions1648515p_re_ven_tions
privations15310105p____rivations
procreations1647255p_rocr_eations
profanations17175255p_r_ofanations
pronations12314035p____ronations
prorations12314435p_r_or__ations
prorogations1556705p_r_orogations
protonations1449045p_r_otonations
pulverizations28104485pulverizations
purgations1346745pur_g___ations
purifications2047465pur_ifications
reaggregations1762845reaggregations
realizations21415525__realizations
reanimations1468785__reanimations
recitations13314195__re_citations
recombinations2095585recombinations
recreations13412235__recr_eations
recriminations1856725recriminations
rededications1746115rede_dications
redefinitions1752335rede_finitions
reexaminations23153415reexaminations
regulations12310715__reg_ulations
regurgitations16133145__regurgitations
reifications17411825__reifications
relegations1248975releg___ations
relubrications1854195relubrications
remediations1548275reme_di_ations
remigrations15227795remigr__ations
renegotiations15113375renegotiations
renominations15108295re_nominations
reorientations1465195__reorientations
reoxidations2046045__reoxidations
repatriations15136515repatri_ations
replications16811055__replications
repristinations17193925repristinations
reprobations1647775__reprobations
reradiations1349495rer_adi_ations
reregistrations1672825reregistrations
reregulation1346415rereg_ulation_
resegregation1563905resegregation_
reservations1588585rese_r_vations
resignations1346875__resignations
respirations14410305__respirations
retributions14134945__retributions
retrogradations17151645retrogradations
revaccinations2153615revaccinations
revegetations17114715reveg_etations
rubrications1646265__rubrications
ruinations1039605__r__uinations
ruminations1349395__r_uminations
segregations1445805__segregations
serializations23710925serializations
seriations10316675__se_ri_ations
serrations10313055ser__r__ations
suberizations2468755sube_rizations
supererogations1862825supere_rogations
supernations14410875supe_r_nations
temporizations2785735temporizations
tenderizations2455675tenderizations
termination131311165ter__mination_
terrorization2256655terrorization_
theorizations2576125_theorizations
trepanations1444575_tre_panations
trephination1754035_trephination_
trepidations1554935_tre_pidations
urinations10310685____urinations
velarizations2549265ve_larizations
venerations14411285vene_r__ations
verbalizations2849165verbalizations
verifications21159965ver_ifications
vernalizations2649245vernalizations
vernations13310325__ve_r_nations
versifications22166905versifications
veterinarians1662795vete_rinarians

Search took 9 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.1231452772.4
2DLD Change Limit950242808.56311097.0
3Display Results2802800.1861505.4
 (SQL Overall)1786912808.87220141.0
 
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.