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

107 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
pretrain1031092(None) 
pretrains11410141pretrains
retrain7615421_retrain
detrain8412252_detrain
pertain92714962pert_ain
preordain12124492preordain
pretorian11511552pretorian
pretrained1357062pretrained
pretrial10511982pretrial
pretrim11310782pretr_im
refrain10310042_refrain
restrain8311702_restrain
retain64523282_ret_ain
retrains8314532_retrains
appertain1345273appertain
certain92612213cert_ain
cretin82917913cret__in
detain74617383_det_ain
detrains9411763_detrains
distrain9412243distrain
drivetrain1452063drivetrain
entrain7313073_entrain
eyestrain1243433eyestrain
forebrain1445163forebrain
mistrain10311943mistrain
overtrain1259783overtrain
pearmain1245833p_earmain
peregrin1146993peregr_in
pertains102113423pert_ains
petrale9312623p_etrale
petsai838083p_etsai_
petsais938433p_etsais
portrait10510323portrait
praetorian1256633praetorian
prearming14139223prearming
precrash1544823precrash
predawn1335353pre_dawn
predraft1447593predraft
predrying1645343predrying
prefrank1764233prefrank
preman104117453pre_ma_n
preobtain1343993preobtain
preoral9312673preora_l
preordains13124523preordains
prepaid12310133pre_paid
preparing14311643preparing
preplan1149953prepla_n
preprint12314183prepr_int
prerace11414123pre_race
preradio1145723pre_radio
pretape113511623pret_ape
pretaping1439133pretaping
pretax152310193pret_a_x
preteen939873pret_een
preterit10315843preterit
pretermit1347133pretermit
pretorial11512653pretorial
pretorians1258313pretorians
pretraining1446503pretraining
pretravel1444123pretravel
pretreat10311923pretreat
pretreating1448893pretreating
pretreats1146933pretreats
pretrials1158143pretrials
pretrims1238983pretrims
prettying1536043prettying
pretyping1764943pretyping
prevail1238243pre_vail
prewarn124410153pre_warn
prewrap14104973prewra_p
prewraps15114053prewraps
prochain1548483prochain
protamin121210543protamin
protean92412193protea_n
protein92414733prot_ein
protract12510603protract
protrade1148213protrade
pterin81014153pte_r_in
pyrethrin1764403pyrethrin
quatrain1745823quatrain
reattain846733_reattain
redrawn11245953_redrawn
refrains1139593_refrains
regain74517763_re_gain
remain85919863_re_main
reordain9135573_reordain
reran57329103_re_ra_n
restrains9311623_restrains
restraint9412753_restraint
retail65522073_ret_ail
retains74522253_ret_ains
retrace91417343_retrace
retracing12313293_retracing
retrack131310723_retrack
retract91318113_retract
retrained10411313_retrained
retrainee9511163_retrainee
retral64419743_retra_l
retrial7615553_retrial
retrim83514883_retr_im
retrying122410453_retrying
seatrain847923seatrain
strain64919573__strain
terrain7410853_terrain
train56529113___train
urethan1045473uretha_n
vitrain1038943_vitrain

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.403443402.0
2DLD Change Limit1461621077.89318517.9
3Display Results1071070.0462326.1
 (SQL Overall)1786911078.34221420.6
 
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.