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

215 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
preterms123722(None) 
preterm11310161preterm_
peters86624592p_eter_s
praters94921652prater_s
prearms11369172pre_arms
prefers123713332prefer_s
preforms1537402preforms
presters103419002prester_s
preteens1038122preteens
pretells1047332pretells
pretends11299112pretends
preterit10315842preterit
preterits11410962preterits
pretermit1347132pretermit
pretermits1445032pretermits
pretests10310012pretests
pretexts1735602pretexts
pretors9316812pretor_s
pretrims1238982pretrims
preverbs15295302preverbs
prewarms15406732prewarms
preyers124412362preyer_s
reteams9339562_reteams
retems83914572_rete_ms
ureters7311822ureter_s
aretes64425353arete__s
brewers123811063brewer_s
craters95021893crater_s
degerms1135623_degerms
deperms1236603_deperms
deters74724683_deter_s
dieters83216433dieter_s
erecters102611613erecter_s
fraters103517213frater_s
freers94717303fre_er_s
fretters113410303fretter_s
graters85419743grater_s
greeters92610113greeter_s
heteros10312683_heteros
kraters114212343krater_s
meeters94714543meeter_s
meters85625833_meter_s
midterms13284863midterms
misterms123711353misterms
palters94021683palter_s
pasterns104112623pasterns
pasters94531733paster_s
paters84935833p_ater_s
patterns10439943patterns
patters94825193patter_s
peelers93615593peeler_s
peepers113713673peeper_s
peers75130273p_e_er_s
pelters93720313pelter_s
performs1547483performs
periderms1444993periderms
perms95524513p___erms
perter84422283perter__
perturbs1244363perturbs
perverts1337533perverts
pesters93827093pester_s
petards104311153p_etards
peter74427593p_eter__
petered103314973p_etered
petrels9279373p_etrels
petters93722363petter_s
pewters124113353pewter_s
piecers114112253piecer_s
pietisms1247463pietisms
platers93924093plater_s
pleaters103613793pleater_s
poetess938933poete_ss
porters93722703porter_s
posterns102713723posterns
posters93928013poster_s
potters94024343potter_s
pouters94221873pouter_s
powters124015663powter_s
praetors1039833praetor_s
prater84825353prater__
prates84633163prate__s
prayers124212853prayer_s
prealters1147773prealter_s
prearm104512353pre_arm_
preavers13910263preaver_s
prebends13347883prebends
precedes13310713precedes
precents123015043precents
precepts14268893precepts
precess11310863prece_ss
precures12312903precures
preeners102712813preener_s
preens85020113pre_e_ns
prees75937173pre_e__s
prefects1598133prefects
prefer113813203prefer__
prefires134313283prefires
preform1439613preform_
preggers12236833pregger_s
preheats1339413preheats
prelects1299723prelects
prelims1139823pre_lims
premeds12389593preme_ds
premieres13288233premieres
premiers122911653premier_s
premiums1437533premiums
prepares122014163prepares
prepregs13144763prepregs
prepress12137983prepress
presells1058283presells
presents103315643presents
preserve13108803preserve
preserves14109073preserves
presets94216423prese_ts
presorts105311683presorts
pressers103215023presser_s
prester93519623prester__
presterna1145263presterna
prestores114716083prestores
prestress1138133prestress
pretapes122811533pretapes
preteen939873prete_en
pretell938243prete_ll
pretence122312123pretence
pretences132312613pretences
pretend104011013prete_nd
pretense10199823pretense
pretenses112210593pretenses
preterite11613203preterite
preterites12411793preterites
pretest9517633prete_st
pretext1639663prete_xt
pretor8315753pretor__
pretreat10311923pretreat
pretreats1146933pretreats
pretrim11310783pret_rim
pretties10615133pretties
pretypes15337263pretypes
pretzels1934033pretzels
prevents133012293prevents
preverb14317063prever_b
prewarm14479613prewarm_
prewarns13456943prewarns
prewires133811013prewires
preworks17599013preworks
prexes154915953prexe__s
preyer114413733preyer__
prezes173614693preze__s
pricers113915063pricer_s
priers84521193pr_ier_s
primeros12336883primeros
primers114215673primer_s
printers103214903printer_s
priseres10310823priseres
prizers183911843prizer_s
probers113514583prober_s
proems104711163pr_oe_ms
propers113619033proper_s
prosers94219643proser_s
proteans102811543proteans
proteas92015123prote_as
protects1239743protects
proteges1149923proteges
proteids11259943proteids
proteins102114283proteins
protends113010353protends
proteome12228423proteome
proteomes13248653proteomes
protests10310493protests
proteus92511593prote_us
protiums1238553protiums
protoderms1544403protoderms
proverbs15315583proverbs
provers123817793prover_s
pruners93710723pruner_s
pryers115012243pr_yer_s
punters93617043punter_s
putters94219193putter_s
pyrethrums2051463pyrethrums
raters63936583_rater_s
rearms85114653_re_arms
redeems1037163_redeems
refers93921083_refer_s
reforms1239823_reforms
rehems113410983_rehe_ms
renters74224813_renter_s
reperks13298093_reperks
resters74130403_rester_s
retards85015003_retards
reteam83214533_reteam_
retears72814923_retears
retells73211523_retells
retem74221953_rete_m_
retenes76324623_retenes
retests73813853_retests
retires74726213_retires
retorts76016513_retorts
retrims93612373_retrims
retros63820193_ret_ros
returns79712593_returns
reverbs12368863_reverbs
reveres103621343_reveres
revers94529633_rever_s
reverts104715043_reverts
rewarms12439603_rewarms
rezeros1647453_rezeros
teeters74018303teeter_s
terms75523473___terms
treaters83615843treater_s
ureter6313203ureter__
ureteral856233ureteral
ureteric1046243ureteric
urethras1174613urethras
wresters112711733wrester_s
writers105513493writer_s

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622157.98618302.3
3Display Results2152150.0762828.9
 (SQL Overall)1786912158.48221067.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.