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

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

176 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
pretzel183514(None) 
pretzels1934031pretzels
petrel83111532p_etrel
prequel1836342prequel
preteen939872preteen
pretell938242pretell
prezes173614692pre_zes
arete56031353aret_e_
aretes64425353aret_es
artel56122743ar_t_el
betel74419903_bet_el
bethel1169643_bethel
bezel165215173_be_zel
breeze17298963breeze_
breezed19287053breezed
breezes18318693breezes
brothel12318193brothel
creel75121483cre__el
crenel84213063cre_nel
crewel114310483cre_wel
dreidel934473dreidel
freeze18349513freeze_
freezer19348523freezer
freezes193310353freezes
fresnel1035893fresnel
fretful1346143fretful
fretted113411853fretted
fretter103412753fretter
fritzes19329453fritzes
hertzes1938303hertzes
kreutzer2141273kreutzer
kreuzer2032353kreuzer
pastel85918713past_el
patzer173111643p_atzer
peel65535613p_e__el
pencel103812913p_encel
perter84422283pert_er
petal76526893p_et_al
peter74427593p_et_er
petrels9279373p_etrels
petrol82714063p_etrol
petted94121523p_etted
petter83924773p_etter
pettle84116053p_ettle
peytrel1264253peytrel
pieties9419223pieties
plotzed19376223plotzed
plotzes18317703plotzes
poetize18310773poetize_
poetized2037983poetized
poetizer1936813poetizer
poetizes19310253poetizes
poitrel936193poitrel
potzer174411213p_otzer
prate75135983prat_e_
prated94924923prat_ed
prater84825353prat_er
prates84633163prat_es
prattle9208833prattle
preaged11612333preaged
preanal9310713preanal
preaver121011613preaver
prebill1138803prebill
preboil1148953preboil
precool1139013precool
predial103815413predial
pree67044733pre__e_
preed85128123pre__ed
preen75925053pre__en
preened103214993preened
preener93114833preener
prees75937173pre__es
prefer113813203pre_fer
prefile123413183prefile
premeal11310523premeal
premed114617763pre_med
premeet11615153premeet
premen105017803pre_men
premie103617993premie_
premier113515633premier
premies113823063premies
preoral9312673preoral
prepill1147583prepill
prepped11329903prepped
prepreg12165963prepreg
prequels1934833prequels
presale9416353presale
prese75228383pre_se_
presell939303presell
preset84430983pre_set
pressed103317313pressed
presser93717623presser
presses93523153presses
prester93519623prester
pretape113511623pretape
pretaped13339133pretaped
pretapes122811533pretapes
pretax152310193pret_ax
preteens1038123preteens
pretells1047333pretells
pretend104011013pretend
preterm11310163preterm
pretest9517633pretest
pretext1639663pretext
pretold1049083pretold
pretor8315753pret_or
pretors9316813pretors
pretravel1444123pretravel
pretreat10311923pretreat
pretrial10511983pretrial
pretrim11310783pretrim
prettied1159253prettied
prettier1069043prettier
pretties10615133pretties
prettily1337283prettily
pretty11510873pret_ty
pretype14387483pretype
pretyped16306123pretyped
pretypes15337263pretypes
prevail1238243prevail
preview1536473preview
prevue1179163prevue_
prevued1337143prevued
prevues1239263prevues
prexes154915953pre_xes
prexies163415003prexies
preyed125313203pre_yed
preyer114413733pre_yer
prez156126313pre_z__
prithee1239933prithee
prize164718943pr_ize_
prized184415393pr_ized
prizer174714883pr_izer
prizes173819813pr_izes
proette9312363proette_
proettes10312763proettes
propel103714063pr_opel
protea82214763prot_ea
protei82615313prot_ei
protyl11308213prot_yl
protyle12229453protyle
prythee1545383prythee
putzed18409113p_utzed
putzes174212523p_utzes
quetzal2543013quetzal
ratel54224883_rat_el
rebel73421293_re_bel
reel45240533_re__el
refeel93913243_refeel
refel84920813_re_fel
refuel93912623_refuel
reheel93610823_reheel
repel74921403_re_pel
retail65522073_retail
rete44944133_ret_e_
retell63813643_retell
retem74221953_ret_em
retial64724993_retial
retie55735303_retie_
retied75924983_retied
reties65436193_reties
retile65929673_retile
retool63914483_retool
retral64419743_retral
retted74826313_retted
revel84423163_re_vel
ritzes154812943_ritzes
spaetzle1942243spaetzle
spritzed2044803spritzed
spritzer1944563spritzer
spritzes1946943spritzes
teazel15368543_teazel
tressel73010893tressel
tzetze1432733tzetze_
tzetzes1532673tzetzes
ureter6313203uret_er

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271767.58017681.7
3Display Results1761760.0632793.7
 (SQL Overall)1786911768.04922200.4
 
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.