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

188 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
preteens103812(None) 
preteen939871preteen_
peebeens1243062peebeens
posteens10309732posteens
poteens92910882p_oteens
potteens10256792potteens
preens85020112pr__eens
pretells1047322pretells
pretend104011012pret_end
pretends11299112pretends
pretense10199822pret_ense
preterms1237222preterms
pretests10310012pretests
pretexts1735602pretexts
pretzels1934032pretzels
proteans102811542proteans
proteins102114282proteins
retenes76324622_retenes
aretes64425353aret_e_s
canteens1038573canteens
cretins93216423cret_ins
fifteens1442753fifteens
freshens14298313freshens
fretless1138063fretless
fretters113410303fretters
greatens9307593greatens
greens75716873gr__eens
greeters92610113greeters
greisens954653greisens
greyhens1542633greyhens
ketenes114813503_ketenes
lateens74210553_lateens
nineteens943773nineteens
pasterns104112623pasterns
patens84820863p_at_ens
pattens95414923p_attens
patterns10439943patterns
peahens12307573p_eahens
pectens11189203p_ectens
peebeen1143903peebeen_
peens76428193p___eens
peetweets1442013peetweets
peewees1236803peewee_s
pentenes10315633pentenes
pereons92815003p_ereons
pertains102113423pertains
pertness10310093pertness
peters86624593p_et_ers
petrels9279373p_etrels
petters93722363p_etters
pewees11311393p_ewee_s
pieties9419223pietie_s
platens94213983plat_ens
poetess938933poet_ess
poetless1038723poetless
posteen93512623posteen_
posterns102713723posterns
postteens1144373postteens
poteen83514263p_oteen_
potheens13266483potheens
potteen9319673potteen_
praters94921653prat_ers
prates84633163prat_e_s
preavers13910263preavers
prebend12319443pre_bend
prebends13347883prebends
prebless1236823prebless
precedent1448873precedent
precedents1545723precedents
precedes13310703precedes
precent113520263pre_cent
precents123015043precents
precepts14268893precepts
precess11310863pre_cess
precleans1344893precleans
predawns1444363predawns
preeing103817673pre_eing
preen75925053pr__een_
preened103214983pre_ened
preener93114833pre_ener
preeners102712813preeners
prees75937173pr__ee_s
prefects1598133prefects
prefers123713333pre_fers
preggers12236833preggers
preheats1339413preheats
prelects1299723prelects
premeds12389583pre_meds
premeet11615153premee_t
premen105017803pre_men_
premiers122911653premiers
premies113823063premie_s
prenomens1347073prenomens
prepense12238943pre_pense
preplans1249613preplans
prepregs13144763prepregs
prepress12137983prepress
prequels1934833prequels
prescreens1443843prescreens
presells1058273presells
present94022733pre_sent
presents103315643presents
presets94216423pre_sets
pressers103215023pressers
presses93523153presse_s
presterna1145263presterna
presters103419003presters
prestress1138133prestress
pretapes122811533pretapes
pretell938233pret_ell
pretence122312123pretence
pretences132312613pretences
pretenders1345243pretenders
pretenses112210593pretenses
preterit10315843preterit
preterits11410963preterits
preterm11310153pret_erm
pretest9517633pret_est
pretext1639663pret_ext
pretors9316803pret_ors
pretrains11410143pretrains
pretreat10311923pretreat
pretreats1146933pretreats
pretrims1238983pretrims
pretties10615133pretties
pretypes15337263pretypes
pretzel1835143pretze_l
prevent124016553pre_vent
prevents133012293prevents
preverbs15295303preverbs
previews1634513previews
prevues1239263prevue_s
prewarns13456943prewarns
prexes154915943pre_xe_s
prexies163415003prexie_s
preyers124412363pre_yers
prezes173614693pre_ze_s
proceeds1335973proceeds
proettes10312763proette_s
propenes122816513propenes
protean92412193protean_
proteas92015123prot_eas
protects1239743protects
protegees1275393protegees
proteges1149923proteges
proteids11259943proteids
protein92414733protein_
protend104012793prot_end
protends113010353protends
protests10310493protests
proteus92511593prot_eus
protons93118003prot_ons
puttees93612913puttee_s
ratteens8256053ratteens
rattens74213403_rattens
reddens9259783_reddens
redeems1037163_redeems
refeeds11368973_refeeds
refeels10379693_refeels
regreens9257453_regreens
reheels10298253_reheels
remeets93712413_remeets
reopens939373_reopens
reseeds84012333_reseeds
reseeks11348623_reseeks
reseen64318413_reseen_
resees63827483_resee_s
retains74522253_retains
reteams9339563_reteams
retears72814923_retears
retells73211523_retells
retems83914573_ret_ems
retene69224273_ret_ene
retests73813853_retests
reties65436193_retie_s
retines75134673_retines
retunes76918403_retunes
returns79712593_returns
sateens73710753_sateens
shebeens1343333shebeens
sixteens1542943sixteens
subteens1037423subteens
sweetens11255433sweetens
teens56227483___teens
terreens8246533terreens
treens65317873tr__eens
ureters7311823uret_ers
urethans1145243urethans

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621887.73318901.1
3Display Results1881880.0802350.0
 (SQL Overall)1786911887.96922423.3
 
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.