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

170 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
prepress1213798(None) 
prepregs13144761prepregs
repress92712681_repress
depress10239872_depress
derepress1243582derepress
peeress939502p_eeress
prebless1236822prebless
precess11310862pre_cess
preparers13197672preparers
prepares122014162prepare_s
prepreg12165962prepre_g
preprocess1644052preprocess
prestress1138132prestress
prioress1035392prioress
progress1137022progress
redress82511872_redress
regress82711452_regress
compress1439053compress
crepes105419343crep_e_s
crepiest12310383crepiest
crewless1335413crewless
cropless1237793cropless
cypress1434653_cypress
deepness1136443deepness
dripless1135243dripless
egress73310433__egress
empress1138163_empress
express1637493_express
freeness11710443freeness
freres94716173fre_re_s
fretless1138063fretless
greyness1235243greyness
heiress1036813_heiress
hotpress1344303hotpress
impress1137773_impress
ireless72312243ire_less
oppress1135993_oppress
oratress834553oratress
outpress10118183outpress
paperers122410453paperers
paperless1345833paperless
peepers113713673peep_ers
peerless1037513peerless
pegless1038053p_egless
peppers103311443p_eppers
peres76246643p_e_re_s
perses85428063p_e_rses
pertness10310093pertness
petrels9279373p_etrels
phereses1348093phe_reses
pheresis1377633phe_resis
pipeless12107663pipeless
poetess938933poe_tess
poetless1038723poetless
popeless1288473popeless
porteress1137933porteress
portress1038323portress
prearms11369173prear_ms
preavers13910263preavers
precises123218333precises
precrash1544823precrash
precrease1345233precrease
precreases1445653precreases
precrisis1346453precrisis
precures12312903precure_s
predries112714383predries
preeners102712813preeners
preens85020113pre__ens
preerect1259273preerect
preerects1345413preerects
prees75937173pre__e_s
prefers123713333pre_fers
prefires134313283prefire_s
preggers12236833preggers
premeds12389593pre_meds
premiers122911653premiers
premies113823063premie_s
premises123018273premises
premiss113513813pre_miss
preorders1235403preorders
prepacks1836583prepacks
prepare111913623prepare__
prepared132210873prepare_d
preparer12169643prepare_r
prepaves15189193prepaves
prepays1437483prep_ays
prepense12238943prepense
preplans1249613preplans
prepossess1443083prepossess
prepped11329903preppe_d
preppies1149693preppies
preppiest1236983preppiest
preppiness1344423preppiness
preprice1488873preprice
preprices1569263preprices
preprint12314183preprint
preprints1347473preprints
preps96220693prep___s
prepubes1436053prepubes
prepubis1443643prepubis
prepuces1438583prepuces
prepupas1144133prepupas
prequels1934833prequels
presets94216423pre_sets
press75425953___press
pressers103215023pressers
presses93523153presse_s
presters103419003presters
preteens1038123preteens
preterms1237223preterms
pretest9517633pre_test
pretests10310013pre_tests
pretreat10311923pretreat
pretreats1146933pretreats
pretrims1238983pretrims
pretzels1934033pretzels
preverbs15295303preverbs
previews1634513previews
previses133814283previses
prevues1239263prevue_s
prewires133811013prewire_s
prewraps15114053prewraps
prexes154915953pre_xe_s
prexies163415003prexie_s
preyers124412363pre_yers
prezes173614693pre_ze_s
priestess1145293priestess
primness1276763primness
princess12266803princess
process11310403pr_ocess
procuress1344093procuress
profess1237713pr_ofess
propels113412843prop_els
properest1349663properest
properness1445923properness
propers113619033prop_ers
prophesy1844453prophesy
prophets1539503prophets
propjets1935493propjets
proposes122515973proposes
prowess1237903pr_owess
pulpless12224953pulpless
pumpless14236373pumpless
purebreds1442163purebreds
pureness101110183pure_ness
rearers74323563_rearers
recess8314263_re_cess
recross989833_recross
redness82012443_redness
reexpress1842793reexpress
refresh1335453_refresh
regrets83212923_regrets
repass84114703_rep_ass
repegs93311943_rep_egs
repels84318763_rep_els
reperks13298093_reperks
reposes94021263_reposes
repressed12610103_repressed
represser1168953_represser
represses11412143_represses
repressor1166343_repressor
reprise92715043_reprise
reprises102615463_reprises
reprocess1345933_reprocess
repros84216003_repr_os
restress82511773_restress
seeress7311573_seeress
suppress1236443suppress
treeless839283treeless
winepress1443633winepress

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.720248181.9
2DLD Change Limit1461621707.51619446.8
3Display Results1701700.0602833.3
 (SQL Overall)1786911708.29621539.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.