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

349 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
peyotes123848(None) 
peyote1139851peyote_
peyotls1233631peyotls
cenotes92814542cenotes
coyotes12410702coyotes
demotes104717672demotes
denotes83817002denotes
devotes113713752devotes
emotes84620282_emotes
gemotes103712142gemotes
keynotes1543632keynotes
pekoes124410422peko_es
pelites93821992pelites
pelotas9410722pelotas
penates93321592penates
peones83821042pe_ones
petites93820202petites
peyotl1146232peyot_l
pyoses114314302p_yoses
remotes94521612remotes
revotes104716392revotes
aerates74627483aerates
aerobes9311493aerobes
azotes154312223_azotes
becomes132911963becomes
behoves15177353behoves
berates94126853berates
besots86415453besot_s
beyonds1335063beyonds
bytes105217493_by_tes
capotes11314643capotes
celotex1635023celotex
cenote83715843cenote_
cerates95428233cerates
cerites94823433cerites
certes84623083ce_rtes
cetes75731103ce__tes
chayotes1636493chayotes
cotes76347843__cotes
coyote11411783coyote_
debates103718523debates
debones103315113debones
decodes113914983decodes
delates83526283delates
deletes83117933deletes
demoses103815823demoses
demote94817803demote_
demoted114313543demoted
denote74118043denote_
denoted93512763denoted
depones103717093depones
deposes103117213deposes
depots94716343depot_s
deputes104911783deputes
derates84028883derates
detoxes1538803detoxes
devote104513783devote_
devoted124111093devoted
devotee113811823devotee
devotees12286283devotees
dotes65836693__dotes
elates65032363_elates
elites66027123_elites
elopes85918163_elopes
elutes64020313_elutes
emote75421193_emote_
emoted94614923_emoted
emoter85415193_emoter
emoters94712873_emoters
enates64026423_enates
epazotes1943773epazotes
epidotes1147023epidotes
epodes94315563_epodes
eposes84418783_eposes
erodes74819883_erodes
eroses65327053_eroses
evites94916473_evites
evokes13459683_evokes
eyases94513683_eyases
eyes75837883_ey__es
eyres84921773_ey_res
eyries93816813_eyries
fetes85630143fe__tes
flytes123911563fly_tes
fyttes1236933_fyttes
garotes8614563garotes
gelates83219583gelates
gemote94613023gemote_
gemots93712153gemot_s
genomes103611703genomes
gentes75324163ge_ntes
geodes8412153ge_odes
gestes75721393ge_stes
guyots1036003guyot_s
helots95217703helot_s
heroes94923823hero_es
hexones17299143hexones
hexoses17228883hexoses
jetes124922843je__tes
kayoes134710823kayo_es
kentes105118643ke_ntes
ketones115014503ketones
ketoses114912873ketoses
keyholes1844593keyholes
keynote1443903keynote_
keynoted1642783keynoted
keynoter1542383keynoter
keynoters1642313keynoters
keysets1434343keysets
keyster14256153keyster
keysters15326333keysters
kytes125012913_ky_tes
legates82917673legates
lenites7818443lenites
leones64417723le_ones
litotes7311183litotes
meioses9310833meioses
metates92720003metates
metes74736213me__tes
metopes11311363metopes
motes75944003__motes
myopes13419963_myopes
myoses114013843_myoses
negates83215833negates
notes55034583__notes
operates10515403operates
palates93624933palates
paroles95025883paroles
pastes85233913p_astes
pates76047893p__ates
payees114812903pay_ees
payoffs1843243payoffs
payolas12148973payolas
payors114312643payo_rs
payouts1247303payouts
peaces106324083pe_aces
peaches144120053peaches
peages94321843pe_ages
pearter9412743pearter
peartest10311293peartest
peases85229473pe_ases
peats76140193pe_at_s
peavies122213393peavies
pebbles1337573pebbles
pectates122213933pectates
pecten102711103pe_cten
pectens11189203pe_ctens
pedate93117763pedate_
peddles112913693peddles
pedes85327283pe__des
peeries93623023peeries
pees65257373pe___es
peeves113814873pe_eves
peewees1236803peewees
pegboxes2043143pegboxes
peises84125043pe_ises
pekes114623563pe__kes
pekoe114612363peko_e_
pelages10714613pelages
peles75738083pe__les
pelite84323003pelite_
pellets94014783pellets
pelmets11309693pelmets
pelorus939273pelorus
pelota8612833pelot_a
peloton938743peloton
pelotons1038913pelotons
pelted94617753pe_lted
pelter83321623pe_lter
pelters93720313pe_lters
pelts76128813pe_lt_s
pelves114514663pe_lves
penes75839223pe__nes
penises9318193penises
penlites10312263penlites
pennies94218813pennies
penoches1538933penoches
pensees9311203pensees
penster92811953penster
pensters103012123pensters
pentodes11310363pentodes
pentose9311593pentose
pentoses10312893pentoses
peonies93620153peonies
peons75327183pe_o_ns
peoples11312213peoples
peploses1269463peploses
pepos96620083pepo__s
peptones12311033peptones
perches143717953perches
perdues103511333perdues
peres76246643pe__res
peritus9311803peritus
perlites10316353perlites
permutes1238713permutes
perorates11417013perorates
perries93226603perries
perses85428063pe_rses
perter84422283pe_rter
pertest9317043pe_rtest
perukes133210113perukes
peruses94018163peruses
pesades10310893pesades
pesetas938753pesetas
pesos77221623peso__s
pester84827593pe_ster
pesters93827093pe_sters
pestles93217693pestles
pestos84719083pe_stos
pests75933273pe_st_s
peter74427593pe__ter
peters86624593pe__ters
petioles10311633petioles
petite84320653petite_
pets66248333pe__t_s
petted94121523pe_tted
petter83924773pe_tter
petters93722363pe_tters
pettles93916483pettles
pewees11311393pe_wees
pewits112810683pewit_s
pewter114013673pe_wter
pewters124113353pe_wters
peytrel1264253peytrel
peytrels1363373peytrels
phenates13611563phenates
phloxes1935513phloxes
phones114121213p_hones
photos113316633p_hotos
phots105418493p_hot_s
physes14399783phy_ses
phytols15276553phytols
phytons15319063phytons
picoted1239213picoted
picotee11311473picotee
picotees1247113picotees
picots104616443picot_s
pieholes13168913pieholes
piloted10310323piloted
pilots84018873pilot_s
pinites9319533pinites
pinoles93418703pinoles
pinones94717073pinones
pinots85920273pinot_s
pintoes95117713pintoes
pirates93020323pirates
pistes85325633p_istes
pivoted1336513pivoted
pivots115111903pivot_s
plates85432243p_lates
plots75025673p_lot_s
plotzes18317693p_lotzes
podites103014733podites
poets76024443p__oets
pointes93216753pointes
pokes116133013p__okes
poles75351003p__oles
pomes94833933p__omes
pones74547043p__ones
pontes83627853p_ontes
pooves113914713p_ooves
popes95933813p__opes
pores75849033p__ores
poses74642763p__oses
posoles9314883posoles
pots66452363p__ot_s
poxes145325723p__oxes
poyous112911623poyo_us
pozoles1839063pozoles
prates84633163p_rates
precodes13711573precodes
predates11615803predates
prelates10418563prelates
probes104119453p_robes
proles84627203p_roles
promotes12314123promotes
proses84733473p_roses
protea82214763p_rotea
proteas92015123p_roteas
protei82615303p_rotei
protest9317533p_rotest
proteus92511593p_roteus
proves114322253p_roves
psyches1755803psyches
psyops1334343psyo_ps
ptoses83514673p_toses
pupates113311433pupates
pyes95528993p_y__es
pyosis114012123p_yosis
pyres105523883p_y_res
pyrites12812203pyrites
pyrones123113303pyrones
pyropes142210193pyropes
pyxes175911403p_y_xes
pyxies18338293p_yxies
quotes153312463_quotes
rebates95123173rebates
rebores95319163rebores
recites93524583recites
recodes102918633recodes
redates83423863redates
redoes74623753redo_es
redoxes15310883redoxes
refutes104515723refutes
relates73731423relates
remates93827103remates
remote84222603remote_
remoter94815973remoter
remotest103310723remotest
removes124514713removes
rentes65431193re_ntes
reposes94021263reposes
repots85621003repot_s
reputes94615963reputes
reroutes8312223reroutes
resites74027793resites
resoles73823653resoles
revokes144212503revokes
revote94917453revote_
revoted114314153revoted
rezones163213943rezones
rotes56143903__rotes
ryots85313783_ryot_s
sapotes9313933sapotes
sedates83418033sedates
senates73322583senates
senores73218113senores
shotes95321893_shotes
telomes9310533telomes
testes65125823te_stes
totes55139683__totes
trystes10419993trystes
unyokes1466733unyokes
velites103417303velites
veloutes1136153veloutes
verites103822253verites
verstes104014273verstes
vetoes92914083veto_es
votes84627083__votes
wytes114113433_wy_tes
xeroses143612823xeroses
xeroxes13246443xeroxes
yentes95517603ye_ntes
yokes125223023__yokes
yores85031323__yores
yowes114926373__yowes
yperites13310153yperites
zeroes154314343zero_es
zygotes20355163zygotes

Search took 6 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.1561145455.1
2DLD Change Limit1340273495.59323963.3
3Display Results3493490.1103172.7
 (SQL Overall)1786913495.85930498.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.