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

185 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
feod81552300(None) 
fed76548351fe_d
feed84538901feed
fend84832971fend
feods99516851feods
feud86523021feud
food86830571food
aeon45634612aeon
apod78123182apod
bead75937922bead
bed67950622be_d
bend76435262bend
bod67055542_bod
clod76124612clod
cod69660122_cod
coed77140542coed
dead65434242dead
deed65340902deed
ed38645182_e_d
eld46733792_eld
end46834352_end
eon36052082_eon
fad77452412f_ad
fado87226462fado
fard85639062fard
fe57944742fe__
feal713940422feal
fear75337792fear
feat76458222feat
feck134923432feck
feds85234312feds
fee66862012fe_e
feeb96924542feeb
feeds94921142feeds
feel75233842feel
fees76450602fees
feet75352212feet
feh96136092fe_h
fehs106522382fehs
felid94717172felid
fell76833072fell
felon84619292felon
felt75146932felt
fem86040732fe_m
feme96130542feme
fems96428702fems
fen66851352fe_n
fends96324972fends
fens76139762fens
feoff10711052feoff
fer66646122fe_r
fere76342232fere
fern76129322fern
fes66551672fe_s
fess76529162fess
fest74949442fest
fet66471632fe_t
feta76528902feta
fete75734922fete
feted94420932feted
fetid93715982fetid
fetor81214532fetor
fets75345942fets
feu67843662fe_u
feuds95914882feuds
feued94715662feued
feus75830752feus
few95436962fe_w
fey95940882fe_y
fez156236822fe_z
fid76847682f_id
fido87726392fido
field95015322field
fiend95312982fiend
find87532602find
fiord94313342fiord
fjeld16465582fjeld
fjord16477022fjord
fled85429772fled
floc95922122floc
floe76129772floe
flog85523892flog
flood95215602flood
flop96925452flop
flow105924922flow
fob86748332f_ob
foe66350812f_oe
foes76543442foes
fog76945562f_og
foh98135892f_oh
fold86528942fold
fon66352272f_on
fond86330952fond
foods95924162foods
fool75330592fool
foot76248012foot
fop86743702f_op
for66952072f_or
ford86835492ford
fou66743782f_ou
fox136737862f_ox
foy96044262f_oy
freed95223542freed
fremd115010322fremd
fro65530642fro_
froe75329992froe
frog85624362frog
from96923922from
frond95316342frond
frow106425052frow
fud76335152f_ud
fund85624982fund
ged57044532ge_d
geed65435502geed
geld65828432geld
geode7412592geode
geoid74215762geoid
god57449792_god
good66531802good
head87137172head
heed86437602heed
held85330402held
herd84933062herd
hod76852462_hod
hoed87837982hoed
hood85132332hood
jeed125428502jeed
jeon116821442jeon
lead56038852lead
led46254552le_d
lend56233672lend
leud57223422leud
lewd85716592lewd
mead75531602mead
med66146742me_d
meed74934702meed
meld75830472meld
mend75334032mend
meou65325862meou
meow95117882meow
mod69054402_mod
mood76332062mood
need54934152need
neon47026422neon
nerd56624942nerd
nod47549562_nod
od39255242__od
ped66751522pe_d
peed76239182peed
pend75934532pend
peon65635242peon
plod76723272plod
pod66351482_pod
pood75934322pood
prod76129502prod
quod145413622quod
read55942532read
red46755802re_d
redd66323172redd
redo56029362redo
reed55549622reed
rend56136572rend
resod64720052resod
rod47953892_rod
rood56733002rood
seed55549482seed
send55237292send
shod86225062shod
sod46053702_sod
ted46446562te_d
teed55439262teed
tend56433772tend
tod49457072_tod
toed56137042toed
trod57627952trod
veld85323202veld
vend86626422vend
wed75843622we_d
weed85637512weed
weld84727732weld
wend85330452wend
wood85329382wood
yeld811423872yeld
yod77545502_yod
zed135431172ze_d

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 Limit298721850.84335435.3
3Display Results1851850.0503700.0
 (SQL Overall)1786911851.173152336.7
 
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.