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

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

138 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
presentations154813(None) 
presentation1448991presentation_
presentational1673212presentational
preservations1895542preservations
representations17153892representations
assentations1245833_assentations
cementations1659013_cementations
fermentations1856273fermentations
frequentations2652243frequentations
orientations1246913or_ientations
perennations1447253p_erennations
personations1448393person_ations
pigmentations1854093pigmentations
placentations17103633placentations
premeditations1955013premeditations
preselections17144443preselections
presentative1755343presentati_ve
preservation1776283preservation_
preventatives2152933preventatives
preventions1648533preven__tions
protestations1555813protestations
recantations1448873_recantations
representation16154123representation_
reservations1588583_reservations
restations10315843_res__tations
alimentations1594994alimentations
argumentations1783274argumentations
assentation1146184_assentation_
augmentations1654124augmentations
cementation1559704_cementation_
crenations12511694cr__en_ations
crenelations1446184crene_lations
crenellations1553574crenellations
crepitations1647474cre_pitations
decantations1547944_decantations
delectations1547454_delectations
dentations11413634___dentations
desecrations1559214_desecrations
detestations1347584_detestations
dissertations1465894dissertations
emendations1446054__emendations
fermentation1756824fermentation_
fomentations1746794_fomentations
forestations1546324fores__tations
fragmentations20213564fragmentations
frequentation2552634frequentation_
gestations1139774_ges__tations
hebetations1656464_hebe_tations
hesitations1448544_hes_itations
implementations2162884implementations
indentations1347884_indentations
lamentations1495984_lamentations
mentations12312584___mentations
orientation1147574or_ientation_
ornamentations1673254ornamentations
ostentations1246124_ostentations
peltations12311554p___eltations
penetrations1448854p_enetrations
perennation1348084p_erennation_
permeations1549884perme__ations
permutations1646504p_ermutations
perpetrations1746374perpetrations
perpetuations1754984perpetuations
persecutions1654794perse_cutions
perseverations1953244perseverations
personation1349484person_ation_
perspirations1786174perspirations
pigmentation1754484pigmentation_
placentation1694154placentation_
plantations1347474p__lantations
potentiations1555184p_otentiations
preadaptations1951754preadaptations
precipitations2085394precipitations
preconditions1854894preconditions
predations13812154pr__e_dations
predestinations1865004predestinations
predications17411184pre_dications
preemptions17134854pre_e_mptions
preformations2045714preformations
prehensions1645944prehen__sions
preignitions1554004preign_itions
prelections151210474prele__ctions
prelibations16127624pre_libations
premeditation1855704premeditation_
premonitions1646854premon_itions
premunitions1644984premun_itions
prenotions1248294pr__en_otions
preparations1648314pre_parations
prescriptions19135334prescriptions
preseasons1244054prese__a_sons
preselection16154884preselection_
presentient1348324presen__tient
presenting131013024presen__ti_ng
presentisms1555214presen__tisms
preservationist2062804preservationist
preservatives2152784preservatives
presetting131010834prese_t_ti_ng
presumptions18153884pres_umptions
pretensions1347084preten__sions
pretentious13125594preten__tious
preventative2054314preventati_ve
prevention1549174preven__tion_
profanations17175254profan_ations
prolongations1673354prolongations
pronations12314034pr__on_ations
prosecutions1645614prose_cutions
prostitutions1554254prostitutions
prostrations1449764pros_trations
protestation1456364protestation_
protonations1449074proton_ations
recantation1349864_recantation_
recitations13314204_re_citations
refutations1448674_re_futations
regenerations1447144_regenerations
regimentations1784854_regimentations
relegations1248974_rele_gations
reluctations1446754_reluctations
remediations1548274_remediations
reorientations1465214_reorientations
repetitions1378024_repe_titions
replantations1544864_replantations
representatives20211894representatives
reputations13410734_re_putations
resections121513034_rese__ctions
reservation1489144_reservation_
resignations1346884_resignations
respirations14410304_respirations
restation9316914_res__tation_
restitutions1275704_restitutions
restorations12410954_restorations
retentions101611114_reten__tions
revegetations17114714_revegetations
revelations14410304_reve_lations
segmentations1655594segmentations
sensations1059854___sensations
sustentations1354784sustentations
trepanations1444574trepan_ations
vegetations1547324_vege_tations

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 Filter178691950240.343520965.0
2DLD Change Limit950241384.89319420.4
3Display Results1381380.0761815.8
 (SQL Overall)1786911385.31233639.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.