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

490 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
prelates1041857(None) 
predates11615811predates
prelate9519691prelate_
relates73731431_relates
chelates132713842chelates
corelates11314862corelates
creates95225202cre_ates
cremates124216002cremates
delates83526282_delates
elates65032362__elates
gelates83219582_gelates
palates93624932p_alates
pelages10714612p_elages
pelites93821992p_elites
penates93321602p_enates
perlites10316362perlites
phenates13611572phenates
plates85432242p__lates
prates84633162pr__ates
prealter1048862prealter
prealters1147772prealters
prebakes1639012prebakes
predate10616892predate_
predated12513272predated
prefaces15311062prefaces
prefades1439532prefades
pregames1339002pregames
prelacies13310052prelacies
prelatic12311282prelatic
prelatism1347852prelatism
prelatures1245722prelatures
prelives13310382prelives
prelocates1468352prelocates
preludes1137832preludes
prenames12311642prenames
prepares122014162prepares
prepastes13128822prepastes
prepaves15189192prepaves
preplaces1578752preplaces
presages11312202presages
presales10315262presales
pretapes122811532pretapes
pretastes11119422pretastes
primates121515932primates
privates131812372privates
probates12414282probates
prolate9419792prolate_
pronates10418372pronates
prorates10418072prorates
rebates95123182_rebates
redates83423872_redates
reflates113115662_reflates
relaces93420882_relaces
relate64033632_relate_
related83327572_related
relater73723142_relater
relaters83218152_relaters
relaxes143215322_relaxes
remates93827112_remates
replates102919272_replates
reslates83619502_reslates
ablates92416903_ablates
acetates102013063acetates
acrylates1446683acrylates
acylates1339743acylates
adulates9311913adulates
aerates74627493_aerates
agemates111110023agemates
alates64833963__alates
apholates1449683apholates
arenites8917103arenites
areolate81014453areolate_
areolated1089713areolated
aretes64425353are__tes
arsenates979373arsenates
belated103520013_belated
berates94126873_berates
breathes134212903bre_athes
breaths124411183bre_aths
brewages1436383brewages
bromates12413143bromates
cerates95428253_cerates
chelate122914893chelate_
chelated142610483chelated
cholates132414763cholates
collates103019143collates
corelate10516013corelate_
corelated12411823corelated
correlates1248673correlates
crates85736063cr__ates
creases94020963cre_ases
create85126383cre_ate_
created104323453cre_ated
cremate113816183cremate_
cremated133412963cremated
crenate93317113crenate_
crenated113013913crenated
crenelates1266193crenelates
crewmates16375803crewmates
dealates92716683dealates
debates103718533_debates
deflates123013943deflates
delate73827753_delate_
delated93722873_delated
deletes83117933_deletes
deprecates1547283deprecates
depredates1445493depredates
derates84028893_derates
dilates83220663_dilates
elate55335883__elate_
elated74725823__elated
elater64724203__elater
elaters74420193__elaters
elevates111110423elevates
elites66027123__elites
eluates72014683__eluates
elutes64020313__elutes
emulates10312573emulates
enates64026433__enates
epilates10313503epilates
eremites10312603eremites
ergates8314493er_gates
fellates11312753fellates
ferrates113013423ferrates
folates103218453_folates
foredates13310053foredates
frigates12310933frigates
gallates92815523gallates
gelate73421253_gelate_
gelated93615633_gelated
gelatis83313513_gelatis
gelatos83111513_gelatos
gradates10510783gradates
grates75429893gr__ates
greases84816713gre_ases
greaten83610643gre_aten
greatens9307593gre_atens
greater84416493gre_ater
greatest939863gre_atest
greats76318393gre_at_s
greaves113311443gre_aves
grenades1038433grenades
ideates8313733ide_ates
imprecates1645403imprecates
inflates11512193inflates
isolates8613513isolates
iterates81317823iterates
keelages1335743keelages
legates82917683_legates
malates93522603_malates
maleates103316343maleates
metates92720013_metates
misrelates1247623misrelates
negates83215843_negates
oblates91913243_oblates
oleates7417833ole_ates
operates10515413operates
oppilates1345453oppilates
orates64328613or__ates
ovulates1148523ovulates
oxalates1557063oxalates
palaces114216453p_alaces
palate84226783p_alate_
paleate94120003paleate_
palettes103112833palettes
palliates11311033palliates
palpates122613063palpates
pates76047893p___ates
peaces106324083p_e_aces
peages94321853p_e_ages
peases85229473p_e_ases
peats76140193p_e_at_s
pectates122213953pectates
peculates132112543peculates
pedate93117763p_edate_
peerages1189893peerages
pelage9515363p_elage_
peles75738083p_el__es
pelite84323003p_elite_
pellets94014783p_ellets
pelmets11309693p_elmets
pelotas9410723p_elotas
peltate92013773p_eltate_
pelted94617763p_el_ted
pelter83321623p_el_ter
pelters93720313p_el_ters
pelts76128813p_el_t_s
pelves114514663p_el_ves
penlites10312273penlites
percales12313803percales
percolates14410413percolates
perennates1256763perennates
perlite9317323perlite_
permeates13311773permeates
permutes1238713permutes
perorates11417023perorates
pervades1437353pervades
pesades10310903p_esades
petites93820203p_etites
peyotes1238483p_eyotes
phenate12412193phenate_
phenolates1547013phenolates
phonates13410643phonates
phorates13413043phorates
picrates122013213picrates
pileate93815923pileate_
pileated112711133pileated
pillages113012613pillages
pirates93020333p_irates
placates12311753placates
places104323703p__laces
plages94520153p__lages
planes85028083p__lanes
plate74635113p__late_
plated95225773p__lated
platen84518203p__laten
platens94213983p__latens
plater84427693p__later
platers93924093p__laters
platies93722543p__laties
plats75531373p__lat_s
platys11459853p__latys
pleases94515483ple_ases
pleated103816633ple_ated
pleater93916333ple_ater
pleaters103613793ple_aters
pleats85218593ple_at_s
pleiades1145753pleiades
poleaxes1767273poleaxes
pollutes1037613pollutes
populates132710673populates
pralines102217723pralines
prases84429023pr__ases
prate75135983pr__ate_
prated94924923pr__ated
prater84825353pr__ater
praters94921653pr__aters
prats76333393pr__at_s
praxes156215183pr__axes
preaches153214893preaches
preacted132710943preacted
preacts113211363pre_acts
preaged11612333pre_aged
preamps1336613pre_amps
prearms11369173pre_arms
preaver121011613pre_aver
preavers13910263pre_avers
prebade12310283prebade_
prebake1539093prebake_
prebaked1737173prebaked
precasts1239453precasts
precedes13310713precedes
precipes143212213precipes
precises123218333precises
precited133013813precited
precludes1445053precludes
precodes13711573precodes
precures12312903precures
precuts111710473precut_s
predatism1447283predatism
predator11310053predator
predators12310083predators
predawns1444363predawns
predeaths1544743predeaths
predicates15410823predicates
predries112714383predries
preemies12512193preemies
prees75937173pre___es
prefabs1435163prefa_bs
preface14510923preface_
prefaced1638423prefaced
prefacer1537983prefacer
prefacers1636293prefacers
prefade1339013prefade_
prefaded1537823prefaded
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
preflame1545913preflame_
pregame1239553pregame_
preheated1539813preheated
preheater1448913preheater
preheaters1557193preheaters
preheats1339413preheat_s
prelacy1437583prela_cy
prelatisms1445703prelatisms
prelature1146263prelature
prelaw1139103prela__w
prelected1439133prelected
prelects1299723prelects
prelife1279943prelife_
prelims1139823prel_ims
preloaded1335923preloaded
preloads1157513preloads
prelocate13109513prelocate_
prelocated1597183prelocated
prelude1038013prelude_
preluded1236473preluded
preluder1135733preluder
preluders1234423preluders
premade12311443premade_
prematures1447053prematures
premies113823063pre_mies
premises123018273premises
premixes193110083premixes
prename11412643prename_
prenatal1048373prenatal
prepacks1836583prepacks
prepare111913623prepare_
prepared132210873prepared
preparer12169643preparer
preparers13197673preparers
prepaste12139083prepaste_
prepasted14137673prepasted
prepave14228873prepave_
prepaved16177233prepaved
prepays1437483prepa_ys
preplace1488983preplace_
preplaced1676483preplaced
preplans1249613prepla_ns
preppies1149683preppies
prepubes1436053prepubes
prepuces1438583prepuces
prerace11414123prerace_
presage10312293presage_
presaged1238803presaged
presager1138443presager
presagers1236943presagers
presale9416353presale_
presets94216423preset_s
preshapes1667093preshapes
presides11414913presides
preslices1338213preslices
presses93523153pre_sses
prester93519623pre_ster
presters103419003pre_sters
prestos93716083pre_stos
prests84021263pre_st_s
presumes1239843presumes
pretape113511623pretape_
pretaped13339133pretaped
pretaste10139523pretaste_
pretasted12147963pretasted
pretest9517633pre__test
pretties10615133pretties
pretypes15337263pretypes
preunites1138933preunites
prevails1337663prevails
prevalues1445323prevalues
previses133814283previses
prevues1239263pre_vues
prewarms15406733prewarms
prewarns13456943prewarns
prewashes1744753prewashes
prewires133811013prewires
prexes154915953pre__xes
prexies163415003pre_xies
prezes173614693pre__zes
primages13159273primages
primate111516283primate_
priorates11410763priorates
private121513263private_
privater13158533privater
privatest14196733privatest
probate11414483probate_
probated13410863probated
proettes10312763proettes
profanes132311573profanes
prolans9314273prola_ns
prolapse12134913prolapse
prolapses13145573prolapses
prolately1445773prolately
proles84627203prol__es
prolines102619693prolines
promotes12314123promotes
pronate9418873pronate_
pronated11414053pronated
propanes122415823propanes
prorate9418733prorate_
prorated11513713prorated
proselytes1544743proselytes
prostates11314423prostates
protases102115033protases
pulsates1048813pulsates
pupates113311433p_upates
purslanes1145523purslanes
pyelitis1346583pyelitis
pyruvates1743133pyruvates
rates55352013_r__ates
reales64934123_re_ales
realter73716313_realter
realters83614043_realters
realties8514853_realties
reatas64021013_re_atas
reaves94127573_re_aves
rebate84424113_rebate_
rebated103619703_rebated
rebater93517913_rebater
rebaters103413943_rebaters
rebatos92913113_rebatos
recanes93222263_recanes
recites93524583_recites
reclames12310893_reclames
recrates102420373_recrates
redate74124683_redate_
redated93120923_redated
refaces123216743_refaces
reflate103516263_reflate_
reflated123514293_reflated
refutes104515733_refutes
regales83520793_regales
regelates10311113regelates
reglazes1846793_reglazes
regrates92618403_regrates
regulates101211723_regulates
relabel938163_relabel
relabels1045343_relabels
relace83122153_relace_
relaced103517213_relaced
relands85214883_relands
relapse947703_relapse
relapses1038033_relapses
relatives1239963_relatives
relator74016363_relator
relators83316123_relators
relaxed153312533_relaxed
relaxer143410223_relaxer
relaxers15298263_relaxers
relayed113212753_relayed
relays94316753_rela_ys
releases8313343_releases
relegates10310943_relegates
relets64025673_relet_s
releves103914973_releves
relies65036423_rel_ies
relines75331323_relines
relives104619443_relives
relocates11712933_relocates
relumes9612513_relumes
remakes134116173_remakes
remate84428683_remate_
remated103522473_remated
remotes94521613_remotes
renames92418053_renames
rentes65431193_re_ntes
repaves123513653_repaves
replaces123114123_replaces
replate93420053_replate_
replated112817523_replated
repletes102812473_repletes
reputes94615963_reputes
resales74724903_resales
resites74027793_resites
reslate73520593_reslate_
reslated93517523_reslated
restates83423433_restates
retakes113718863_retakes
retapes93917423_retapes
retastes82212903_retastes
retaxes143615093_retaxes
revotes104716393_revotes
rewakes144614983_rewakes
rewaxes173911333_rewaxes
rotates72819773_rotates
sedates83418043_sedates
senates73322613_senates
seriates82620673seriates
serrates82617023serrates
slates64934063__slates
solates73523853_solates
sporulates1246483sporulates
sublates10315003sublates
toeplates1147183toeplates
treated83618703tre_ated
treater74219833tre_ater
treaters83615843tre_aters
treaties8316983tre_aties
treats64821693tre_at_s
ululates848433ululates
unrelated10310433unrelated
uprates93814863upr__ates
uralites82112723uralites
urates65027763ur__ates
ureases74416723ure_ases
urinates8314133urinates
velate93720143_velate_
velites103417303_velites
violates11311193violates
wreathes14299893wre_athes
wreaths13338373wre_aths

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.406440125.6
2DLD Change Limit1461624906.89021213.6
3Display Results4904900.2032413.8
 (SQL Overall)1786914907.49923828.6
 
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.