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

141 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
pretrim1131078(None) 
pretrims1238981pretrims
retrim83514881_retrim
prearm104512352prear_m
prelim10311422pre_lim
preterit10315842preterit
preterm11310162preterm
pretrain10310922pretrain
pretrial10511982pretrial
retrims93612372_retrims
begrim11118333_begrim
chetrum1445343chetrum
cretic102816283cret_ic
cretin82917913cret_in
erethic1257723erethic
erethism1345863erethism
heretrix1845133heretrix
interim9912873interim
megrim1178043_megrim
metric10314673_metric
oratrix1444533oratrix
overtrim1337483overtrim
paretic113016673paret_ic
peerie83617893p_eerie
peregrin1146993peregrin
peri65636973p_e_ri_
peril75425953p_e_ril
peris75537073p_e_ris
perm85834633p_e_r_m
pertain92714963pertain
petit74332653p_et_it
petrel83111533p_etrel
petrify1536573p_etrify
petrol82714063p_etrol
petti75119453p_etti_
phratric1545943phratric
pietism1139113pietism
pilgrim1244643pilgrim
plectrum1453953plectrum
poetic10416843poet_ic
poetries10315583poetries
poetry1139383poetr_y
prairie938333prairie
prearms11369173prearms
prebid113512843pre_bid
preboil1148953preboil
preboom1348253preboom
precis103416703pre_cis
predried12309573predried
predries112714383predries
predrill1145933predrill
predry1237873predr_y
preedit10512463preedit
preemie11310563preemie
prefire124012813prefire
prefix18356853pre_fix
preform1439613preform
prelims1139823pre_lims
premie103617993pre_mie
premium13310363premium
premix173710333pre_mix
preoral9312673preoral
prepaid12310133prepaid
preppie1058093preppie
prepreg12165963prepreg
preprice1488873preprice
preprint12314183preprint
preriot9316413pre_riot
preship1439793preship
prestrike1547493prestrike
pretape113511623pretape
pretax152310193pret_ax
preteen939873preteen
pretell938243pretell
pretend104011013pretend
preterite11613203preterite
preterits11410963preterits
pretermit1347133pretermit
preterms1237223preterms
pretest9517633pretest
pretext1639663pretext
pretold1049083pretold
pretor8315753pret_or
pretorial11512653pretorial
pretorian11511553pretorian
pretors9316813pretors
pretrains11410143pretrains
pretreat10311923pretreat
pretrials1158143pretrials
pretrimmed1742633pretrimmed
prettied1159253prettied
prettier1069043prettier
pretties10615133pretties
prettify1644343prettify
prettily1337283prettily
pretty11510873pret_ty
pretype14387483pretype
pretzel1835143pretzel
prevail1238243prevail
prewarm14479613prewarm
prewire124311143prewire
prewrap14104973prewrap
prim85132203p___rim
program12311693program
prometric15410643prometric
propria1149933propria
proprium1447373proprium
protei82615313protei_
proteid103513673proteid
protein92414733protein
protium11312293protium
pterin81014153pte_rin
putrid9311173p_utrid
pyrethrin1764403pyrethrin
pyrethrum1951783pyrethrum
pyretic143210783pyret_ic
rearm75923573_rear_m
rectrix1645363_rectrix
rerig64018483_re_rig
retail65522073_retail
retain64523283_retain
reteam83214533_reteam
retem74221953_ret_em
retia55326113_ret_ia
retie55735303_ret_ie
retime85321803_ret_ime
retire64927013_retire
retrain7615423_retrain
retral64419743_retral
retrial7615553_retrial
retried84419153_retried
retries74129073_retries
retro55020953_retr_o
retros63820193_retros
retry84718083_retr_y
tetri52716453_tetri_
tetris62816293_tetris
trim65329523___trim
untrim8310683_untrim
ureteric1046233ureteric
uretic82914353uret_ic

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.406440125.6
2DLD Change Limit1340271416.32621186.7
3Display Results1411410.0463065.2
 (SQL Overall)1786911416.77826363.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.