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

151 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
prepense1223894(None) 
pretense10199821pretense
propense122410101propense
preens85020112pre_ens_
prepensely1753312prepensely
prerinse1038632prerinse
presence122213512presence
pretence122312122pretence
pretenses112210592pretenses
propene112716042propen_e
propenes122816512propenes
arpens84814823ar_pens_
credence1387823credence
creese84014333cre_e_se
crepes105419343crepe_s_
crepons1139323crepons_
deepens10307813deepens_
defense1137503_defense
dispense11129783dispense
expense16127873_expense
greenie8310123gre_enie
greens75716873gre_ens_
peens76428193p_e_ens_
peepers113713673peepers_
permease1246503permease
perpend12259353perpen_d
perpended1546083perpended
perpends13227753perpends
perpent112318813perpen_t
perpents122312043perpents
perverse1336103perverse
pigpens1235503pigpens_
prebend12319443preben_d
prebends13347883prebends
precede1239653prece_de
precedes13310713precedes
precensor1345253precensor
precent113520263precen_t
precented14310693precented
precents123015043precents
precess11310863prece_ss
precessed1437523precessed
precesses13310463precesses
prechose15129773prechose
precieuse1344613precieuse
precise113518173pre_cise
precrease1345233precrease
preemie11310563pre_emie
preen75925053pre_en__
preened103214993pre_ened
preener93114833pre_ener
prees75937173pre_e_s_
prefers123713333prefers_
prehensile1544663prehensile
premeds12389593premeds_
premen105017803premen__
premise113818553pre_mise
premorse1237553premorse
premune1138933premun_e
prepare111913623prep_are
prepares122014163prepares
prepaste12139083prepaste
prepave14228873prep_ave
prepaves15189193prepaves
prepays1437483prepays_
preplace1488983preplace
preplans1249613preplans_
preppie1058093prep_pie
preppies1149693preppies
prepregs13144763prepregs_
prepress12137983prepress
preprice1488873preprice
preps96220693prep__s_
prepubes1436053prepubes
prepuce1337833prep_uce
prepuces1438583prepuces
prepunch1743643prepunch
prepupae1144643prepupae
prerenal1049083prerenal
prerinsed1246323prerinsed
prerinses1138813prerinses
prese75228383pr__e_se
presences132113793presences
present94022733presen_t
presented12311633presented
presentee11411863presentee
presenter11311643presenter
presents103315643presents
preserve13108803preserve
presets94216423presets_
preteens1038123preteens_
pretences132312613pretences
pretend104011013preten_d
pretended1337193pretended
pretender1246663pretender
pretends11299113pretends
pretest9517633prete_st
prevent124016553preven_t
prevented1539003prevented
preventer1438593preventer
prevents133012293prevents
previse123713793pre_vise
prexes154915953prexe_s_
preyers124412363preyers_
prezes173614693preze_s_
propane112716153propan_e
propanes122415823propanes
propels113412843propels_
propend123311273propen_d
propended1546163propended
propends13249173propends
propenol1246473propenol
propenyl1544583propenyl
propers113619033propers_
prophase15410243prophase
propine113020213propin_e
propines122618933propines
propone112716303propon_e
propones122516963propones
propose112714843prop_ose
protease10209893protease
proteose10229413proteose
prudence1346333prudence
refence12312243_refence
release7312763_release
reopens939373_reopens_
repegs93311943_repegs_
repels84318763_repels_
repent84728873_repen_t
repented112614983_repented
repenter102813863_repenter
repents93717623_repents
repine85627813_repin_e
repines94927383_repines
repins84924313_repins_
repose84121413_rep_ose
reprise92715043_reprise
repulse938193_repulse
response1037753_response
retene69224273_reten_e
retenes76324623_retenes
revenge1138573_revenge
revenue1039533_revenue
reverse103913743_reverse
ripens85012173_ripens_
spense83912433__spense
suspense10135743suspense
terpene92310863terpen_e
terpenes102111573terpenes
treens65317873tre_ens_
trepans92311593trepans_

Search took 8 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.420425454.8
2DLD Change Limit1461621517.09320606.5
3Display Results1511510.0632396.8
 (SQL Overall)1786911517.57623586.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.