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

98 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
prepregs1314476(None) 
prepreg12165961prepreg_
prepress12137981prepress
preparers13197672preparers
prepares122014162prepare_s
repegs93311942_rep_egs
repress92712682_repress
crepes105419343crep_e_s
depress10239873_depress
derepress1243583derepress
freres94716173fre_re_s
paperers122410453paperers
peepers113713673peep_ers
peeress939503p_eeress
peppers103311443p_eppers
peres76246643p_e_re_s
petrels9279373p_etrels
prearms11369173prear_ms
preavers13910263preavers
prebless1236823prebless
precess11310863pre_cess
precrease1345233precrease
precures12312903precure_s
predries112714383predries
preeners102712813preeners
preens85020113pre__ens
preerect1259273preerect
preerects1345413preerects
prees75937173pre__e_s
prefers123713333pre_fers
prefires134313283prefire_s
preggers12236833preggers
premeds12389583pre_meds
premiers122911653premiers
premies113823063premie_s
preorders1235403preorders
prepacks1836583prepacks
prepare111913623prepare__
prepared132210863prepare_d
preparer12169643prepare_r
prepaves15189193prepaves
prepays1437483prep_ays
prepense12238943prep_ense
preplans1249613preplans
prepped11329893preppe_d
preppies1149683preppies
preprice1488873preprice
preprices1569263preprices
preprint12314183preprint
preprints1347473preprints
preprocess1644053preprocess
preps96220693prep___s
prepubes1436053prepubes
prepubis1443643prepubis
prepuces1438583prepuces
prepupas1144133prepupas
prequels1934833prequels
presages11312203presages
presets94216423pre_sets
pressers103215023pressers
presses93523153presse_s
presters103419003presters
prestress1138133prestress
preteens1038123preteens
preterms1237223preterms
pretreat10311923pretreat
pretreats1146933pretreats
pretrims1238983pretrims
pretzels1934033pretzels
preverbs15295303preverbs
previews1634513previews
prevues1239263prevue_s
prewires133811013prewire_s
prewraps15114053prewraps
prexes154915943pre_xe_s
prexies163415003prexie_s
preyers124412363pre_yers
prezes173614693pre_ze_s
prioress1035393prioress
prodrugs1242483prodrugs
progress1137023progress
prolegs10379993pr_olegs
propels113412843prop_els
propers113619033prop_ers
prophets1539503prophets
propjets1935493propjets
purebreds1442163purebreds
rearers74323563_rearers
redlegs936823_redlegs
redress82511873_redress
regress82711453_regress
regrets83212923_regrets
repeg84015053_rep_eg_
repels84318763_rep_els
reperks13298093_reperks
repros84216003_repr_os
rerigs74014793_re_rigs
trepangs11205403trepangs

Search took 10 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.1731032896.0
2DLD Change Limit146162989.43615489.8
3Display Results98980.0801225.0
 (SQL Overall)178691989.68918442.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.