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

94 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
pretreats114693(None) 
pretreat10311921pretreat_
retreats8311411_retreats
preerects1345412preerects
preheats1339412pre_heats
preterits11410962preterits
pretests10310012pret_ests
pretexts1735602pret_exts
pretreated1347622pretreated
pretrials1158142pretrials
retreads937822_retreads
retreat7317532_retreat_
entreats839773_entreats
estreats839423_estreats
intreats8311543_intreats
maltreats1145223maltreats
mistreats1148633mistreats
overeats112415263ove_reats
overtreats1346643overtreats
peetweets1442013peetweets
petrels9279373p_etre_ls
postheats1447433postheats
precents123015043pre_cents
precepts14268893pre_cepts
precleans1344893precleans
preclears1344373preclears
precrease1345233precrease
precreases1445653precreases
predeath1447003pre_death
predeaths1544743pre_deaths
preelects1356083preelects
preerect1259273preerect_
prefects1598133pre_fects
preformats1744413preformats
preheat12413893pre_heat_
prelects1299723pre_lects
prepregs13144763prepre_gs
prepress12137983prepre_ss
preprints1347473preprints
presents103315643pre_sents
presets94216423pre_se_ts
prestress1138133prestre_ss
preteens1038123pret_eens
pretells1047333pret_ells
pretends11299113pret_ends
preterit10315843preterit_
preterite11613203preterite
preterites12411793preterites
pretermits1445033pretermits
preterms1237223pret_erms
pretest9517633pret_est_
pretext1639663pret_ext_
pretheater1545543pretheater
pretorians1258313pretorians
pretrain10310923pretr_ain
pretrains11410143pretrains
pretreating1448893pretreating
pretrial10511983pretria_l
pretrims1238983pretr_ims
pretzels1934033pretze_ls
prevents133012293pre_vents
prewraps15114053prewr_aps
procreate1348143procreate
procreates1448153procreates
proteans102811543prot_eans
proteas92015123prot_ea_s
protects1239743prot_ects
protests10310493prot_ests
protracts1347023protracts
recheats1339193_recheats
recreants1146623_recreants
recreate10313603_recreate
recreates11313363_recreates
redreams1195953_redreams
reerects10319923_reerects
regreets9287853_regreets
regrets83212923_regre_ts
reheats104513523_re_heats
repeats94316053_re_peats
rereads81512293_re_reads
rerents73319423_re_rents
reseats74319583_re_seats
reteams9339563_ret_eams
retears72814923_ret_ears
retests73813853_ret_ests
rethreads1344483_rethreads
retracts101111313_retracts
retread849003_retrea_d
retreated10312623_retreated
retreater9310203_retreater
retreaters1047543_retreaters
retrials8510823_retrials
retroacts1146283_retroacts
treats64821693___treats

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 Filter1786911486410.406440125.6
2DLD Change Limit148641947.56319653.7
3Display Results94940.0462043.5
 (SQL Overall)178691948.01522294.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.