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 “pepo” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

149 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
pepo8762215(None) 
pep76447081pep_
pepos96620081pepos
peps85134511peps
peso66925821peso
repo66027541repo
aero45435342aero
apo511142122_apo
capo85829212capo
cep75736332cep_
cepe84926652cepe
ceps86125952ceps
cero66329452cero
deco76125972deco
demo77427552demo
depot85727922depot
ego46726052_ego
epos66723732_epos
expo1349182expo
helo75332852helo
hep86644142hep_
hero74635782hero
hypo127516352hypo
keno87926432keno
kep96437202kep_
kepi105315632kepi
keps106027302keps
kept106232942kept
keto86223452keto
leno47331392leno
lept66440882lept
levo76820062levo
memo85924792memo
meno66031362meno
pap76758402pap_
papa85827142papa
paps86443452paps
pe47649032pe__
pea56657242pe_a
peag75431342peag
peak106535202peak
peal68648102peal
pean66147172pean
pear69745232pear
peas65755062peas
peat65967932peat
pec76744412pe_c
pech116125452pech
peck125730682peck
pecs84634102pecs
ped66751522pe_d
pedro8313152pedro
peds75835242peds
pee56066512pe_e
peed76239182peed
peek106031432peek
peel65535612peel
peen65938082peen
peep85833692peep
peeps95822362peeps
peer66238352peer
pees65257372pees
peg65843062pe_g
pegs75531762pegs
peh86740962pe_h
pehs95625762pehs
pein65834942pein
peke105926202peke
pekoe114612362pekoe
pele65539552pele
pelf97031452pelf
pelon74423212pelon
pelt67651082pelt
pen56558842pe_n
pend75934532pend
pengo84317592pengo
pens65649642pens
pent66559072pent
peon65635242peon
pepino10310332pepino
pepla9312862pepla
peplos101211542peplos
peppy114310362peppy
per56353092pe_r
pere66450262pere
peri65636972peri
perk106232842perk
perm85834632perm
perp89029892perp
perps95521482perps
pert66759322pert
perv97224812perv
pes57259782pe_s
pesos77221622pesos
pest65555292pest
pesto75723722pesto
pet56477302pe_t
pets66248332pets
petto76021042petto
pew86442302pe_w
pews95731532pews
pip78051042pip_
pipe86434432pipe
pips85837132pips
pipy115421512pipy
piso66727562piso
plop86625742plop
poco86826152poco
polo66236632polo
pomo85828452pomo
poo57757112p_oo
poop86532812poop
pop76252252pop_
pope85535612pope
pops86340952pops
prao66229022prao
preop94715872preop
prep86427672prep_
preps96220692preps
pro55837262p_ro
prop85932812prop
pup76339882pup_
pupa85422812pupa
pups86032232pups
pupu87620712pupu
pyro96019392pyro
redo56029362redo
rep55847802rep_
repos74725792repos
repot75132622repot
repp85418742repp
repro75315912repro
reps65937952reps
sego56525182sego
sepoy10314302sepoy
sept65844362sept
tempo95214972tempo
tepa66021682tepa
tepoy10312162tepoy
topo66932402topo
typo95418122typo
upo58925862_upo
veto76622992veto
wept95635052wept
yep86638962yep_
yeps95924402yeps
zep147129142zep_
zeps156019342zeps
zero134822472zero

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298721490.86034734.9
3Display Results1491490.0304966.7
 (SQL Overall)1786911491.170152727.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.