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

214 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
prepaid1231013(None) 
repaid94716321_repaid
peptid112712372p_eptid
prebid113512842pre_bid
prepack1757642prepack
prepare111913622prepare
prepared132210872prepared
prepave14228872prepave
prepaved16177232prepaved
prepay13310312prepa_y
prepays1437482prepays
prepped11329902prepped
preppie1058092preppie
prevail1238242prevail
relaid75518442_relaid
repair84011462_repair
repand95316062_repand
resaid74517082_resaid
trepid9310082trep_id
unrepaid1143712unrepaid
arepa75615563arepa__
arepas85515713arepa_s
braid85822263br__aid
bread85523113bre_a_d
creped114115723crep_ed
dread74419023dre_a_d
erepsin937393erepsin
foresaid1247803foresaid
mermaid1297853mermaid
nonpaid1048073nonpaid
oread64619603ore_a_d
overpaid14158933overpaid
paid75737493___paid
papain10313793p_apain
peeped113915393peep_ed
pepped103113403p_epped
pepsin10310853p_epsin
peptic122113153p_eptic
peptide122910693p_eptide
peptids12239333p_eptids
peracid12312993peracid
percoid12312323percoid
peroxid17310283peroxid
perpend12259353perpend
pertain92714963pertain
petard95013803p_etard
piebald1245503piebald
plaid85118303p__laid
plead85818463ple_a_d
pleiad947833pleia_d
postpaid1376543postpaid
preach133613923pre_ach
preact103220393pre_act
preaged11612333preaged
preamp1238993pre_amp
prearm104512353pre_arm
prebade12310283prebade
prebake1539093prebake
prebaked1737173prebaked
prebend12319443prebend
prebids12399883pre_bids
prebind123810643prebind
preboard1338263preboard
preboil1148953preboil
prebuild1344303prebuild
precast11314853precast
precava1445093precava
precis103416703pre_cis
predate10616893predate
predated12513273predated
predawn1335353predawn
predial103815413predial
predried12309573predried
preed85128123pre__ed
preedit10512463preedit
preemie11310563preemie
preened103214993preened
prefab1336243prefa_b
prefabs1435163prefabs
preface14510923preface
prefaced1638423prefaced
prefade1339013prefade
prefaded1537823prefaded
prefix18356853pre_fix
prefund1335733prefund
pregame1239553pregame
preguide1255423preguide
prelacy1437583prelacy
prelate9519693prelate
prelatic12311293prelatic
prelaw1139103prela_w
prelim10311433pre_lim
preload1049813preload
premade12311443premade
preman104117453prema_n
premed114617763pre_med
premie103617993pre_mie
premix173710333pre_mix
premold1247863premold
prename11412643prename
prep86427673prep___
prepacked20155653prepacked
prepacks1836583prepacks
preparer12169643preparer
prepares122014163prepares
preparing14311643preparing
prepaste12139083prepaste
prepasted14137673prepasted
prepaves15189193prepaves
prepaving1787233prepaving
prepaying1747973prepaying
prepill1147583prepill
preplace1488983preplace
preplaced1676483preplaced
preplan1149953preplan
preplans1249613preplans
preplant12712913preplant
preppier1156643preppier
preppies1149693preppies
preppily1444593preppily
prepping12309763prepping
preppy1235523prep_py
prepreg12165963prepreg
preprice1488873preprice
prepriced1676643prepriced
preprint12314183preprint
preps96220693prep__s
prepubis1443643prepubis
prepuce1337833prepuce
prepupa1064023prepupa
prerace11414123prerace
preradio1145723preradio
presa74319043presa__
presage10312293presage
presaged1238813presaged
presale9416353presale
prescind1338393prescind
preship1439793preship
preside10715613pre_side
presold1059603presold
presplit1247753presplit
pressed103317313pressed
pretape113511623pretape
pretaped13339133pretaped
pretax152310193preta_x
pretend104011013pretend
pretold1049083pretold
pretrain10310923pretrain
pretrim11310783pretrim
prettied1159253prettied
prevailed1536043prevailed
prevails1337673prevails
prevued1337143prevued
prewar114712583prewa_r
prewarm14479613prewarm
prewarn124410153prewarn
prewash1535213prewash
preyed125313203pre_yed
priapi1037923priapi_
priapic1346023priapic
proband122710243proband
propane112716153propane
propend123311273propend
propped113311963propped
propria1149933propria
prosaic11311163prosaic
proteid103513673proteid
pyrenoid1446873pyrenoid
raid55243083_r__aid
rapid86422033_rap_id
read55942533_re_a_d
readd74617133_re_add
reaped94122453_reaped
rebait8320403_rebait
rebid85121363_re_bid
redid74922393_re_did
regain74517763_regain
regard85215773_regard
reland75920433_reland
remail85017123_remail
remain85919863_remain
remand95618963_remand
renail65020763_renail
repack142412163_repack
repaint9318363_repaint
repaired1148953_repaired
repairs9319973_repairs
repark123511713_repark
repass84114703_repass
repast83520633_repast
repave114813873_repave
repaved133311133_repaved
repay104818453_repa_y
repays113813973_repays
repin75324703_rep_in
repled93319783_repled
replied103914463_replied
repped114616723_repped
resail64418733_resail
resid64124093_re_sid
retail65522073_retail
retain64523283_retain
retard75018933_retard
reward106017643_reward
spread9312533spre_a_d
taxpaid1743093taxpaid
tepid8314313_tep_id
tread64821703tre_a_d
trenail7410813trenail
trepan82511673trepa_n
trepang10257293trepang
trepans92311593trepans
unpaid939473_unpaid
unrepair1042373unrepair

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 Filter1786911340270.423422437.4
2DLD Change Limit1340272146.79619721.5
3Display Results2142140.0762815.8
 (SQL Overall)1786912147.29524495.0
 
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.