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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
preterits1141096(None) 
preterit10315841preterit_
preterite11613201preterite
preterites12411791preterites
pretermits1445031pretermits
preedits1168762pre_edits
pretermit1347132pretermit_
preterms1237222preter_ms
pretests10310012prete_sts
pretexts1735602prete_xts
pretreats1146932pretreats
pretrims1238982pret_rims
arteries8321483ar_teries
arteritis949753ar_teritis
breweries1447583breweries
demerits11310763_demerits
feterita1166463_feterita
feteritas1264893_feteritas
papeteries1446553papeteries
peeries93623023p_e_eries
peewits12105873p_e_ewits
perverts1337533perver_ts
petering112516813p_etering
peters86624593p_eter__s
poetries10315583poet_ries
posterity1448693posterity
potteries11313593potteries
praters94921653prater__s
preadmits1444923preadmits
preaudits1265023preaudits
precents123015043prece_nts
precepts14268893prece_pts
predries112714383pre_dries
preedit10512463pre_edit_
preemies12512193pre_emies
preempts1444543pre_empts
preerects1345413pre_erects
preexist1747963pre_exist
preexists1844733pre_exists
prefects1598133prefe_cts
prefers123713333prefer__s
preheats1339413prehe_ats
prelects1299723prele_cts
prelimits1366013prelimits
premedics1645303premedics
preprints1347473pre_prints
prescripts1644743prescripts
presents103315643prese_nts
preserves14109073preserves
presets94216423prese__ts
presorts105311683presor_ts
presters103419003prester__s
preteens1038123prete_ens
pretells1047333prete_lls
pretences132312613pretences
pretends11299113prete_nds
pretenses112210593pretenses
preterm11310163preter__m
pretest9517633prete_st_
pretext1639663prete_xt_
pretorial11512653pretorial
pretorian11511553pretorian
pretorians1258313pretorians
pretors9316813pretor__s
pretrains11410143pretrains
pretreat10311923pretreat_
pretrial10511983pret_rial
pretrials1158143pret_rials
pretrim11310783pret_ri_m
pretties10615133pret_ties
prevents133012293preve_nts
preverbs15295303prever_bs
previsits1446793previsits
preyers124412363preyer__s
printeries12410633printeries
progerias1248623progerias
protects1239743prote_cts
proteids11259943prote_ids
proteins102114283prote_ins
protests10310493prote_sts
pruderies1247873pruderies
pterins9812993p__terins
pyrethrins1873823pyrethrins
reedits8511743_re_edits
reemits9611303_re_emits
retests73813853_rete_sts
retorts76016513_retor_ts
retreats8311413_retreats
retries74129073_ret_ries
retrims93612373_ret_rims
reveries112518513_reveries
reverts104715043_rever_ts
ureteric1046233ureteri_c
ureters7311823ureter__s
urethritis1353293urethritis

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 Filter1786911486410.406440125.6
2DLD Change Limit148641956.57622603.6
3Display Results95950.0332878.8
 (SQL Overall)178691957.01525472.7
 
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.