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

250 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
precedes1331071(None) 
precede1239651precede_
preceded1438291preceded
precodes13711571precodes
recedes102816061_recedes
precedent1448872precedent
precedents1545722precedents
precents123015042precents
precepts14268892precepts
precess11310862prece_ss
precesses13310462precesses
precipes143212212precipes
precises123218332precises
precludes1445052precludes
precode12311852precode_
precoded1438862precoded
precures12312902precures
prefades1439532prefades
preludes1137832preludes
premeds12389592premed_s
presides11414912presides
proceeds1335982proceeds
recede95515532_recede_
receded112713042_receded
recodes102918632_recodes
secedes103711982_secedes
accedes1237723_accedes
antecedes1245063antecedes
arcades101113193ar_cades
bredes94818473br__edes
breeches15258673breeches
breeder103210043bre_eder
breeders11368893bre_eders
breeds94914883bre_ed_s
breezes18318693bre_ezes
brocades1358713brocades
cedes84927333___cedes
concedes13311063concedes
creches14313093crec_hes
creeds94714773cre_ed_s
creeses93914623cre_eses
decades113615513_decades
decides114217653_decides
decodes113914983_decodes
freckles17126383freckles
freezes193310353fre_ezes
grecizes2035683grecizes
greeds84314283gre_ed_s
grenades1038433grenades
haeredes1246333haeredes
heredes11313133_heredes
operceles1344613operceles
oreides8312023ore_ides
pedes85327293p___edes
peeves113814873p_e_eves
peewees1236803peewe_es
percales12313803percales
perceives1646313perceives
percents122713373percents
percepts14247643percepts
perches143717953perc_hes
pervades1437353pervades
pesades10310903p_esades
pewees11311393p_ewe_es
phereses1348093phereses
pieced113912103pieced__
piecers114112253piece_rs
pieces104217273piec__es
pleiades1145753pleiades
praecipes1544853praecipes
preaches153214893preaches
prebade12310283prebade_
prebakes1639013prebakes
prebends13347883prebends
prebids12399883prebid_s
precasts1239453precasts
precedence1746113precedence
precedences1845513precedences
precedency2053693precedency
preceding15129363preceding
precent113520263prece_nt
precented14310693precented
precept133112513prece_pt
precessed1437523precessed
prechecks2243573prechecks
prechose15129773prechose
precieuse1344613precieuse
precious12310593precious
precipe133012123precipe_
precis103416703prec__is
precise113518173precise_
precised133213413precised
preciser123411663preciser
precisest13259003precisest
precited133013813precited
precleans1344893precleans
preclears1344373preclears
preclude1344903preclude_
precluded1544223precluded
precooks1656763precooks
precools1237703precools
precrease1345233precrease
precreases1445653precreases
precure11312553precure_
precured1339993precured
precuts111710473prec_uts
predates11615813predates
predries112714383predries
preed85128123pre_ed__
preedit10512463pre_edit
preedits1168763pre_edits
preemies12512193preemies
preened103214993pre_ened
preener93114833pre_ener
preeners102712813pre_eners
preens85020113pre_e_ns
prees75937173pr__e_es
prefaces15311063prefaces
prefade1339013prefade_
prefaded1537823prefaded
prefects1598133prefects
prefers123713333prefe_rs
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
pregames1339003pregames
preguides1344863preguides
preheats1339413preheats
prejudges2043133prejudges
prelates10418573prelates
prelects1299723prelects
prelives13310383prelives
prelude1038013prelude_
preluded1236473preluded
preluder1135733preluder
preluders1234423preluders
premade12311443premade_
premed114617763premed__
premedic1546303premedic
premedics1645303premedics
premeet11615153preme_et
premieres13288233premieres
premies113823063pre_mies
premises123018273premises
premixes193110083premixes
prenames12311643prenames
preorder1136463preorder
preorders1235403preorders
prepares122014163prepares
prepaves15189193prepaves
prepense12238943prepense
preppies1149693preppies
prepubes1436053prepubes
prepuces1438583prepuces
presages11312203presages
presales10315263presales
prescores133912173prescores
presells1058283presells
presences132113793presences
presents103315643presents
preserves14109073preserves
presets94216423prese_ts
preside10715613preside_
presided12410553presided
presider11410423presider
presiders1248213presiders
presses93523153pre_sses
presumes1239843presumes
pretapes122811533pretapes
preteen939873prete_en
preteens1038123preteens
pretells1047333pretells
pretences132312613pretences
pretended1337193pretended
pretender1246663pretender
pretenders1345243pretenders
pretends11299113pretends
pretense10199823pretense
pretenses112210593pretenses
preterms1237223preterms
pretests10310013pretests
pretexts1735603pretexts
pretties10615133pretties
pretypes15337263pretypes
prevents133012293prevents
preverbs15295303preverbs
previses133814283previses
prevues1239263pre_vues
prewires133811013prewires
prexes154915953pr__exes
prexies163415003pre_xies
preyed125313203preyed__
preyers124412363preye_rs
prezes173614693pr__ezes
priced115018883priced__
priceless1336883priceless
pricers113915063price_rs
prices104524543pric__es
prickles162511093prickles
prides94324183pr__ides
priseres10310823priseres
procedures1543373procedures
proceed12310553proce_ed
proceeded1544103proceeded
proceeder1444173proceeder
proceeders1543603proceeders
process11310403proce_ss
processes13310233processes
procures1239213procures
propenes122816513propenes
proteges1149923proteges
proteides12238783proteides
provides1439883provides
prudes94215443pr__udes
racemes1139093_racemes
reaccedes1454463_reaccedes
recanes93222263_recanes
recces10614913_rec_ces
receives1339743_receives
recepts113010263_recepts
recess8314263_rece_ss
recesses10312323_recesses
recipes113314463_recipes
recites93524583_recites
recode93618713_recode_
recoded113115033_recoded
recuses94619463_recuses
redes65139133_r__edes
redeyes112910973_redeyes
reeded84022563_re_eded
reeds65430903_re_ed_s
reeves94721493_re_eves
refeeds11368973_refeeds
releves103914973_releves
remedies11310553_remedies
reneges82513593_reneges
reredos838633_reredos
resedas839123_resedas
reseeds84012333_reseeds
resees63827483_rese_es
resides84523283_resides
retenes76324623_retenes
reveres103621343_reveres
reweds104412303_rewed_s
secede93311993_secede_
seceded11319203_seceded
seceder10329573_seceder
seceders11277963_seceders
supercedes1578453supercedes
ureides8311103ure_ides

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.440406115.9
2DLD Change Limit1461622508.25017716.6
3Display Results2502500.2031231.5
 (SQL Overall)1786912508.89320093.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.