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

257 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
preteen93987(None) 
preteens1038121preteens
peebeen1143902peebeen
posteen93512622posteen
poteen83514262p_oteen
potteen9319672potteen
preen75925052pr__een
premeet11615152premeet
premen105017802pre_men
pretell938242pretell
pretend104011012pretend
preterm11310162preterm
pretest9517632pretest
pretext1639662pretext
pretzel1835142pretzel
protean92412192protean
protein92414732protein
reseen64318412_reseen
retene69224272_retene
arete56031353aret_e_
aretes64425353aret_es
between1234693_between
brethren1343783brethren
canteen9411083canteen
cretin82917913cret_in
crewmen1436383crewmen
fifteen1343923fifteen
foreseen1139103foreseen
freemen1238463freemen
freshen133010883freshen
fretted113411853fretted
fretter103412753fretter
greaten83610643greaten
green65522143gr__een
greeted93111383greeted
greeter82812673greeter
greisen856503greisen
greyhen1443193greyhen
grutten885283grutten
ketene106613003_ketene
lateen64014863_lateen
nineteen844153nineteen
pastern94415063pastern
paten74827343p_at_en
pattee84323383pattee_
patten84418193p_atten
pattern93712053pattern
peahen113410133p_eahen
peasen84815963p_easen
pecten102711103p_ecten
peebeens1243063peebeens
peen65938083p___een
peetweet1344973peetweet
peewee11311963peewee_
peewees1236803peewees
penmen10311493p_enmen
pentene9313793pentene
pereon83517453p_ereon
pertain92714963pertain
perter84422283pert_er
pertest9317043pertest
peter74427593p_et_er
petered103314973p_etered
peters86624593p_eters
petrel83111533p_etrel
petted94121523p_etted
petter83924773p_etter
pewee10319973p_ewee_
pewees11311393p_ewees
pieties9419223pieties
pitmen102510793p_itmen
platen84518203plat_en
poetess938933poetess
posteens10309733posteens
postern93615613postern
postmen113110423postmen
postteen1055693postteen
poteens92910883p_oteens
potheen12257893potheen
potmen102713093p_otmen
potteens10256793potteens
prate75135983prat_e_
prated94924923prat_ed
prater84825353prat_er
praters94921653praters
prates84633163prat_es
preaged11612333preaged
preaver121011613preaver
prebend12319443prebend
precede1239653precede
preceded1438293preceded
precedent1448873precedent
precedes13310713precedes
precent113520263precent
precept133112513precept
precess11310863precess
preclean1245893preclean
predawn1335353predawn
pree67044733pr__ee_
preed85128123pr__eed
preeing103817673pre_eing
preened103214993preened
preener93114833preener
preens85020113pre_ens
prees75937173pr__ees
prefect141011073prefect
prefer113813203pre_fer
prefers123713333prefers
preheat12413893preheat
prelect111013833prelect
preman104117453pre_man
premeal11310523premeal
premed114617763pre_med
premeds12389593premeds
premie103617993premie_
premier113515633premier
premies113823063premies
premune1138933premune
prenomen1249633prenomen
prenoon9310043prenoon
preplan1149953preplan
prepped11329903prepped
prepreg12165963prepreg
prequel1836343prequel
prescreen1345103prescreen
prese75228383pre_se_
presell939303presell
present94022733present
preset84430983pre_set
presets94216423presets
presleep1244493presleep
pressed103317313pressed
presser93717623presser
presses93523153presses
pressmen1238833pressmen
prester93519623prester
presterna1145263presterna
presters103419003presters
pretape113511623pretape
pretaped13339133pretaped
pretapes122811533pretapes
pretax152310193pret_ax
pretells1047333pretells
pretence122312123pretence
pretences132312613pretences
pretended1337193pretended
pretender1246663pretender
pretends11299113pretends
pretense10199823pretense
pretenses112210593pretenses
preterit10315843preterit
preterms1237223preterms
pretested12149113pretested
pretests10310013pretests
pretexted19135693pretexted
pretexts1735603pretexts
pretold1049083pretold
pretor8315753pret_or
pretors9316813pretors
pretrain10310923pretrain
pretreat10311923pretreat
pretrim11310783pretrim
prettied1159253prettied
prettier1069043prettier
pretties10615133pretties
pretty11510873pret_ty
pretype14387483pretype
pretyped16306123pretyped
pretypes15337263pretypes
pretzels1934033pretzels
prevent124016553prevent
preverb14317063preverb
preview1536473preview
prevue1179163prevue_
prevued1337143prevued
prevues1239263prevues
prewarn124410153prewarn
preworn124711223preworn
prexes154915953pre_xes
prexies163415003prexies
preyed125313203pre_yed
preyer114413733pre_yer
preyers124412363preyers
prezes173614693pre_zes
prithee1239933prithee
proceed12310553proceed
proette9312363proette_
proettes10312763proettes
propene112716043propene
propmen1338763propmen
protea82214763prot_ea
proteans102811543proteans
proteas92015123proteas
protect11313633protect
protege1059153protege
protegee1156963protegee
proteges1149923proteges
protei82615313prot_ei
proteid103513673proteid
proteins102114283proteins
protend104012793protend
protest9317533protest
proteus92511593proteus
proton84318893prot_on
proven114314773pr_oven
prythee1545383prythee
puttee85919723puttee_
puttees93612913puttees
ratteen7329113ratteen
ratten64217383_ratten
redden83613623_redden
redeem9311533_redeem
refeed104717623_refeed
refeel93913243_refeel
regreen8309043_regreen
reheel93610823_reheel
remeet86325473_remeet
reopen8311573_reopen
resee54336333_resee_
reseed74823293_reseed
reseek103813133_reseek
resees63827483_resees
resewn9459813_resewn
retain64523283_retain
retaken113911803_retaken
rete44944133_ret_e_
reteam83214533_reteam
retear63115483_retear
retell63813643_retell
retem74221953_ret_em
retems83914573_retems
retenes76324623_retenes
retest64028453_retest
retie55735303_retie_
retied75924983_retied
reties65436193_reties
retine66237333_retine
retorn610923433_retorn
retted74826313_retted
retune69121953_retune
return623222523_return
rotten64115433_rotten
sateen63815013_sateen
shebeen1234553shebeen
sixteen1434113sixteen
subteen938523subteen
sweeten10267313sweeten
teen45938203___teen
terreen7257573terreen
treen55622753tr__een
umpteen1143843umpteen
ureter6313203uret_er
ureters7311823ureters
urethan1045473urethan
wreathen14256143wreathen
writhen13407863writhen
written10336343written

Search took 7 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.436409841.7
2DLD Change Limit1340272576.09321996.9
3Display Results2572570.0932763.4
 (SQL Overall)1786912576.62226984.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.