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

190 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
pelf9703145(None) 
delf85436571delf
elf66138521_elf
pele65539551pele
pelfs105016291pelfs
pelt67651081pelt
self75138291self
alef76340692alef
beef96233672beef
bel57148462bel_
bell66237182bell
bels66142492bels
belt65754032belt
calf96339562calf
cel56040552cel_
cell65031722cell
cels65534972cels
celt65646712celt
clef97028182clef
deaf85838402deaf
def76546722de_f
del46752752del_
dele56843082dele
delfs94918672delfs
delft95623322delft
deli55631292deli
dell56938202dell
dels56745472dels
delt57855272delt
eel37946842eel_
eels46536742eels
eely77725212eely
ef57345362_e_f
eff96128622_eff
el26745292_el_
eld46733792_eld
elk76726122_elk
ell36735682_ell
elm57531742_elm
els37645722_els
fell76833072fell
felt75146932felt
gel45642432gel_
geld65828432geld
gels56836102gels
gelt56448012gelt
golf85731182golf
gulf84929422gulf
half106238452half
held85330402held
hell75637892hell
helm95530022helm
helo75332852helo
help95328922help
jell117125872jell
keef115829992keef
kef105639662ke_f
kelp105322802kelp
kelt85343192kelt
kerf115827462kerf
leaf76441032leaf
mel56047482mel_
meld75830472meld
mell64935612mell
mels65941532mels
melt65752892melt
neif75429482neif
pal56761672pal_
pale66055012pale
pall65039342pall
palm85331362palm
palp85828572palp
pals66951352pals
paly95835532paly
pe47649032pe__
pea56657242pe_a
peag75431342peag
peak106535202peak
peal68648102peal
peals75235492peals
pean66147172pean
pear69745232pear
peas65755062peas
peat65967932peat
pec76744412pe_c
pech116125452pech
peck125730682peck
pecs84634102pecs
ped66751522pe_d
peds75835242peds
pee56066512pe_e
peed76239182peed
peek106031432peek
peel65535612peel
peels75226422peels
peen65938082peen
peep85833692peep
peer66238352peer
pees65257372pees
peg65843062pe_g
pegs75531762pegs
peh86740962pe_h
pehs95625762pehs
pein65834942pein
peke105926202peke
peles75738082peles
pelon74423212pelon
pelts76128812pelts
pen56558842pe_n
pend75934532pend
pens65649642pens
pent66559072pent
peon65635242peon
pep76447082pe_p
pepla9312862pepla
pepo87622152pepo
peps85134512peps
per56353092pe_r
pere66450262pere
peri65636972peri
perk106232842perk
perm85834632perm
perp89029892perp
pert66759322pert
perv97224812perv
pes57259782pe_s
peso66925822peso
pest65555292pest
pet56477302pe_t
pets66248332pets
pew86442302pe_w
pews95731532pews
pilaf103923482pilaf
pile65649692pile
pili66130352pili
pill65339462pill
pily96132732pily
plea66830602plea
pleb86123812pleb
pled75231432pled
plew97222812plew
plex137321372plex
ply86323552p_ly
pol56449382pol_
pole65951302pole
poll66332132poll
polo66236632polo
pols66044562pols
poly96235152poly
poof95541662poof
pouf95732642pouf
prof96134662prof
puff125525432puff
pul56138062pul_
pula65129372pula
pule65040952pule
puli65527622puli
pull64731662pull
pulp84825352pulp
puls65437562puls
reef74938212reef
ref66053292re_f
reif76937642reif
rely75428952rely
rolf75134872rolf
seif75638722seif
sel38253322sel_
selfs85220242selfs
sell45840612sell
sels46345982sels
serf76340112serf
shelf115221112shelf
spell75020302spell
spelt75430192spelt
teff106023762teff
tel35647902tel_
tela45532972tela
tele45040872tele
tell44934702tell
tels46841692tels
vela75725542vela
veld85323202veld
weld84727732weld
well75832042well
welt75547862welt
wolf105729562wolf
yeld811423872yeld
yelk115320002yelk
yell76028322yell
yelp95621352yelp

Search took 4 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.233766914.2
2DLD Change Limit298721902.78310733.7
3Display Results1901900.0932043.0
 (SQL Overall)1786911903.10957475.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.