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

162 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
peyotl114623(None) 
peyote1139851peyote
peyotls1233631peyotls
pelota8612832pelota
peyotes1238482peyotes
phytol14366562phytol
befool1137713befool
befoul1137253befoul
begot84625953begot_
behowl1445533behowl
besot76429713besot_
besots86415453besots
beyond1237073beyond
cenote83715843cenote
ceorl7410913ce_orl
coyote11411783coyote
demote94817803demote
denote74118043denote
depot85727923depot_
depots94716343depots
devote104513783devote
dewool1047403dewool
emote75421193_emote
enol45823823_eno_l
extol1247893_extol
gemot84024233gemot_
gemote94613023gemote
gemots93712153gemots
guyot9314523guyot_
guyots1036003guyots
helot85332683helot_
helots95217703helots
ketol95414003keto_l
keynote1443903keynote
keypal1534893keypal
metol75917813meto_l
nerol51017813nero_l
parol74826273paro_l
payoff1736023payoff
payola11208113payola
payor105413843payo_r
payors114312643payors
payout11714653payout
payouts1247303payouts
payroll1245613payroll
peafowl1543193peafowl
peal68648103pe__al
pearl75324463pe_arl
peart76440753peart_
peartly1267453peartly
peat65967933pe_at_
peats76140193pe_ats
peaty105725693pe_aty
pedal86022503pe_dal
pedate93117763pedate
pedocal1237893pedocal
peel65535613pe__el
peepul1035783peepul
pekoe114612363peko_e
pekoes124410423pekoes
pelite84323003pelite
pelon74423213pelo_n
pelotas9410723pelotas
peloton938743peloton
pelt67651083pe_lt_
pelts76128813pe_lts
penal75228373pe_nal
pencel103812913pencel
pencil103712973pencil
penial84120893penial
pensil83013333pensil
pent66559073pe_nt_
pentyl1138813pentyl
penult8314653penult
peon65635243pe_o_n
peons75327183pe_ons
peony105717563pe_ony
people10310183pe_ople
pepo87622153pepo__
pepos96620083pepo_s
peril75425953pe_ril
periti8319953periti
peroral9314793peroral
peroxy1838243peroxy
pert66759323pe_rt_
pertly115312543pe_rtly
peseta8310573peseta
peso66925823peso__
pesos77221623peso_s
pest65555293pe_st_
pestle83215843pe_stle
pesto75723723pe_sto
pestos84719083pestos
pests75933273pe_sts
pesty106421713pe_sty
pet56477303pe__t_
petal76526893pe_tal
petit74332653petit_
petite84320653petite
petrel83111533petrel
petrol82714063petrol
pets66248333pe__ts
petti75119453pe_tti
pettle84116053pe_ttle
petto76021043pe_tto
petty105320293pe_tty
pewit104622793pewit_
pewits112810683pewits
peytral1287503peytral
peytrel1264253peytrel
phenol1149253pheno_l
phot95534353p_hot_
photo104417223p_hoto
phots105418493p_hots
phytols15276553phytols
phyton143610253phyton
picot95031013picot_
picots104616443picots
pilot77435063pilot_
pilots84018873pilots
pinot78737293pinot_
pinots85920273pinots
pistol83313333pistol
pivot106523873pivot_
pivotal1245433pivotal
pivots115111903pivots
plot66141233p_lot_
plots75025673p_lots
plotz164616993p_lotz
pol56449383p__o_l
poll66332133p__oll
polyol1138713polyo_l
pool65835953p__ool
pot58078433p__ot_
pots66452363p__ots
poyou102611523poyo_u
poyous112911623poyous
preboil1148943preboil
precool1139013precool
premolt11312073premolt
protyl11308213p_rotyl
prowl105615123p_rowl
psyops1334333psyops
pyoid11513753p_yoid
reboil83814683reboil
recoal84117973recoal
recoil84016723recoil
remote84222603remote
reoil55321183re_oil
repoll8410793repoll
repot75132623repot_
repots85621003repots
reroll6412683reroll
retool63914483retool
retotal739843retotal
revolt9316223revolt
revote94917453revote
rotl45029683__rotl
ryot75528563_ryot_
ryots85313783_ryots
yowl105820953__yowl
zeroth1837963zeroth

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161627.18615685.5
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.38924183.4
 
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.