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

273 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
precode1231185(None) 
precede1239641precede
precoded1438861precoded
precodes13711571precodes
recode93618711_recode
decode104414742_decode
prebade12310282prebade
preceded1438282preceded
precedes13310702precedes
prechose15129772prechose
precipe133012122precipe
precise113518172precise
preclude1344902preclude
precook1577802precook
precool1139012precool
precoup1336122precoup
precure11312552precure
prefade1339012prefade
prelude1038012prelude
premade12311442premade
prescore124812362prescore
preside10715612preside
recede95515532_recede
recoded113115032_recoded
recodes102918632_recodes
arcade91013643ar_cade
arenose7311373arenose
areole61017283are_ole
become123312593_become
borecole1246623borecole
brede85520503bre__de
bricole112810493bricole
brocade1238533brocade
code77347733___code
creche13310763crec_he
creole8913723cre_ole
crunode1034713crunode
decade104216163_decade
decide104116873_decide
decoded123212383_decoded
decoder113712293_decoder
decodes113914983_decodes
demode104013463_demode
encode9310443_encode
epode85114093__epode
erected103213993erected
erode64520993__erode
forebode1448273forebode
freckle16106643freckle
frescoed1436053frescoed
geode7412593_ge_ode
grecize1935663grecize
grenade938413grenade
miscode12310413miscode
oreide7311673ore_ide
peched144915343p_eched
pecked155019103p_ecked
pekoe114612363p_eko_e
pentode1039893pentode
percale11314093percale
perched154713233perched
percoid12312313percoid
percoids1339663percoids
pericope1447783pericope
period9314983period_
periods10312243periods
pernod9310453pernod_
pernods1038483pernods
pervade1337023pervade
pesade9311103p_esade
peyote1139853p_eyote
piece96717993piec__e
pieced113912103pieced_
piehole12188553piehole
pinecone1246063pinecone
poechore1547853poechore
postcode1346323postcode
praecipe1444633praecipe
preached163412063preached
preacted132710943preacted
preaged11612333preaged
prebake1539093prebake
prebid113512843prebid_
prebids12399883prebids
preboil1148953preboil
prebook1557523prebook
preboom1348243preboom
precast11314853precast
precava1445093precava
precavae1544813precavae
precedent1448873precedent
precent113520263precent
precept133112513precept
precess11310863precess
prechoose16105633prechoose
prechosen16116243prechosen
precious12310593precious
precipes143212213precipes
precis103416703prec_is
precised133213413precised
preciser123411663preciser
precises123218333precises
precited133013813precited
precluded1544213precluded
precludes1445053precludes
precoding15109733precoding
preconize2268633preconize
precooked1844993precooked
precooker1744123precooker
precooks1656763precooks
precooled1446363precooled
precools1237703precools
precured1339993precured
precures12312903precures
precut102016533prec_ut
precuts111710473precuts
predate10616893predate
predive13511083predive
pree67044733pre___e
preed85128113pre_ed_
preemie11310563preemie
preened103214983preened
preface14510923preface
prefaded1537823prefaded
prefades1439533prefades
prefile123413183prefile
prefire124012813prefire
preform1439603preform
prefroze2264673prefroze
pregame1239553pregame
preguide1255423preguide
prejudge1943203prejudge
prelate9519693prelate
prelife1279943prelife
preload1049813preload
preloaded1335923preloaded
preloads1157513preloads
preluded1236463preluded
preluder1135733preluder
preludes1137833preludes
premed114617753premed_
premeds12389583premeds
premie103617993pre_mie
premise113818553premise
premodern1444423premodern
premold1247863premold
premolded1544683premolded
premolds1345843premolds
premolt11312073premolt
premorse1237553premorse
premune1138933premune
prename11412643prename
prenomen1249633prenomen
prenoon9310043prenoon
preop94715873pre_o_p
preops104911943pre_ops
preorder1136463preorder
prepare111913623prepare
prepave14228873prepave
prepped11329893prepped
preppie1058093preppie
prepuce1337833prepuce
prerace11414123prerace
prerock1536723prerock
presage10312293presage
presale9416353presale
prescored14409403prescored
prescores133912173prescores
prese75228383pre__se
presided12410553presided
presider11410423presider
presides11414913presides
presoak1348453presoak
presold1059603presold
presolve1347073presolve
presong1039843presong
presort95219533presort
pressed103317313pressed
prestore104217343prestore
presume11310303presume
pretape113511623pretape
pretold1049083pretold
pretor8315743preto_r
pretors9316803pretors
pretype14387483pretype
previse123713793previse
prevue1179163pre_vue
prevued1337143prevued
prewire124311133prewire
prework164210903prework
preworn124711213preworn
preyed125313193preyed_
price93725413pric__e
priced115018883priced_
pricked164613833pricked
prickle153611013prickle
pride84724733pr__ide
probe94320813pr__obe
proceed12310543proceed
proctodea1443793proctodea
procure1138573procure
prod76129503pr__od_
prods85523553pr__ods
prole74527793pr__ole
promoed12310083promoed
promote11313143promote
prone75332623pr__one
propone112716303propone
propose112714843propose
prose75835123pr__ose
prosody1336433prosody
prove104823193pr__ove
provide1339853provide
provoke1676123provoke
prude84615973pr__ude
rebody1238153_rebody
rebore86625643_rebore
recane83022873_recane
recce9514563_rec_ce
receded112713043_receded
recedes102816063_recedes
rechose121312043_rechose
recipe103414893_recipe
recite83625113_recite
recked134821803_recked
recoal84117973_recoal
recoat84024273_recoat
recock145112723_recock
recoil84016723_recoil
recoin84320293_recoin
recomb1238873_recomb
recon75624243_reco_n
recons84922993_recons
recook125513923_recook
recopy1339043_recopy
record96117423_record
recorded122511063_recorded
recorder11249633_recorder
records105213923_records
recork126315483_recork
recoup10810373_recoup
recoupe11109933_recoupe
recover124312623_recover
recuse85519163_recuse
rede55037663_re__de
redone74820053_redone
remade94316983_remade
remodel1038093_remodel
remote84222603_remote
remove116115573_remove
repose84121413_repose
rerose63320843_rerose
rescore95616193_rescore
reside74224933_reside
resod64720053_resod_
resods74116303_resods
resole64624183_resole
retore67630763_retore
revoke135216243_revoke
revote94917453_revote
rewoke1339521213_rewoke
rewore938030153_rewore
rewove126420073_rewove
rezone153814783_rezone
rode55844303_r__ode
secede93311993_secede
seconde1037413_seconde
subcode1237163subcode
threnode1255423threnode
triode75311893tr_iode
trode65322853tr__ode
ureide7310363ure_ide
wrecked17418333wrecked

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.1431249587.4
2DLD Change Limit1340272737.07618941.1
3Display Results2732730.0932935.5
 (SQL Overall)1786912737.31224438.0
 
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.