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

319 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
fled8542977(None) 
bled75729311bled
fed76548351f_ed
feed84538901feed
filed95331901filed
flea75628491flea
flee76238791flee
flew105824251flew
flex146123471flex
fley106626851fley
flied96519431flied
flued95021251flued
gled65631141gled
led46254551_led
pled75231431pled
sled55334371sled
abed79734132abed
abled86926832abled
aced79540882aced
aged67334252aged
ahed89536252ahed
ailed66240282ailed
ale36572342ale_
alec66430062alec
alee46652322alee
alef76340692alef
ales47067102ales
aped78538152aped
awed88436032awed
axed128829612axed
axled135315812axled
baled85436442baled
bed67950622_bed
bleb85425222bleb
bleed85019802bleed
blend85317452blend
blet66247672blet
blew94722432blew
blued84520322blued
bred75130972bred
clad76225822clad
clef97028182clef
clew95520572clew
clod76124612clod
clued84917682clued
coed77140542coed
coled85540752coled
cred76530882cred
cued76329562cued
deed65340902deed
deled75326542deled
died66137852died
doled75430912doled
dyed96720762dyed
ed38645182__ed
eked96718022eked
eld46733792el_d
exed125420592exed
eyed86623232eyed
fabled124216382fabled
faced117727652faced
fad77452412f_ad
fade85736342fade
faded105025242faded
failed105421602failed
faked135225482faked
famed115928342famed
fard85639062fard
fared95842342fared
fated95632132fated
faxed166220532faxed
fayed126422152fayed
fazed186222962fazed
fe57944742f_e_
feds85234312f_eds
fee66862012f_ee
feeb96924542feeb
feeds94921142feeds
feel75233842feel
fees76450602fees
feet75352212feet
feh96136092f_eh
felid94717172felid
fell76833072fell
felled103720302felled
felt75146932felt
felted103714652felted
fem86040732f_em
fen66851352f_en
fend84832972fend
feod815523002feod
fer66646122f_er
fes66551672f_es
fet66471632f_et
feted94420932feted
feu67843662f_eu
feud86523022feud
feued94715662feued
few95436962f_ew
fey95940882f_ey
fez156236822f_ez
fid76847682f_id
fie67152442fie_
fief107331362fief
field95015322field
fiend95312982fiend
fifed125115972fifed
file75446642file_
filer85433002filer
files85441272files
filet85540162filet
filled104922262filled
filmed124610362filmed
find87532602find
fined94930502fined
fired94829742fired
fixed165416952fixed
fjeld16465582fjeld
flab96628352flab
flag87427082flag
flak116026172flak
flaked144715652flaked
flam96333292flam
flamed124618972flamed
flan76134182flan
flap96128702flap
flared105317602flared
flat77147822flat
flaw106326642flaw
flawed134712722flawed
flax147325632flax
flay106332802flay
flayed134414052flayed
fleam106017282fleam
fleas86423662fleas
fleck148213592fleck
fledge11439292fledge
fledgy14414912fledgy
fleer86020772fleer
flees85828752flees
fleet85932332fleet
flesh115013742flesh
flews115316442flews
flexed17419082flexed
fleyed13408812fleyed
fleys117015602fleys
flic96223732flic
flier86023402flier
flies85630712flies
flip96324262flip
flir76422202flir
flit76539272flit
flited104616582flited
floc95922122floc
floe76129772floe
floes85528142floes
flog85523892flog
flood95215602flood
flop96925452flop
flow105924922flow
flowed133513762flowed
flu66530212fl_u
flub95721882flub
flue75329852flue
flues84626922flues
fluid94013962fluid
fluked145112092fluked
flumed124915262flumed
flus75626542flus
fluted104917162fluted
flux145617742flux
fluxed17509672fluxed
fly97124952fl_y
flyer114916252flyer
flyted13378772flyted
foaled104515962foaled
foe66350812foe_
foes76543442foes
foiled104618402foiled
fold86528942fold
folded114212792folded
foley115222302foley
fond86330952fond
food86830572food
fooled104317822fooled
ford86835492ford
fouled104315972fouled
fowled133914092fowled
foxed165115212foxed
free75940182free
freed95223542freed
fremd115010322fremd
fret75845042fret
fried95322912fried
fud76335152f_ud
fuel76824732fuel
fueled104913602fueled
fugled114813692fugled
fulled103820652fulled
fumed116118822fumed
fund85624982fund
furled104717052furled
fused94820442fused
fuzed185415252fuzed
gaed66031512gaed
ged57044532_ged
geed65435502geed
geld65828432geld
gied64631982gied
glad65624012glad
glede75517832glede
gleds75417892gleds
glee55239062glee
gleed75320572gleed
gleg66219802gleg
glen56027202glen
gley85724652gley
glued75118362glued
haed86338582haed
haled95335822haled
heed86437602heed
held85330402held
hied85434042hied
hoed87837982hoed
holed95634132holed
hued86925852hued
iced78721892iced
idled74915212idled
ilea45931462ilea
ilex115822032ilex
ired55131872ired
isled64615992isled
jeed125428502jeed
lad48165702_lad
lea37660182_lea
lead56038852_lead
lee36068142_lee
leg46446112_leg
lei36846382_lei
lek75640302_lek
lend56233672_lend
les35663072_les
let36481472_let
leu36047402_leu
leud57223422_leud
lev66139422_lev
lewd85716592_lewd
lex107943822_lex
ley66246812_ley
lez125541312_lez
lid47453512_lid
lied55838092lied
med66146742_med
meed74934702meed
meld75830472meld
muled85824432muled
naled65525052naled
need54934152need
offed12359162offed
ogled75915962ogled
ohed87825182ohed
oiled64429472oiled
old47033462ol_d
ole37155212ole_
olea46532722olea
oleo46630482oleo
oles46453472oles
oped76230152oped
owed86833872owed
paled85538722paled
ped66751522_ped
peed76239182peed
pied75035362pied
piled85232992piled
plea66830602plea
plead85818462plead
pleb86123812pleb
plew97222812plew
plex137321372plex
plied85118592plied
plod76723272plod
poled84934842poled
puled84926522puled
red46755802_red
reed55549622reed
rifled104115002rifled
riled65833252riled
rued55729792rued
ruled65822522ruled
seed55549482seed
shed86536152shed
sleds64418852sleds
slew76228232slew
slid55828982slid
slued64220512slued
sned56026052sned
soled65835172soled
sped76031492sped
sued56537932sued
ted46446562_ted
teed55439262teed
tied55535212tied
tiled64832942tiled
toed56137042toed
toled65934922toled
unled64021072unled
used55722822used
veld85323202veld
vied86328632vied
voled95323722voled
waled94330992waled
wed75843622_wed
weed85637512weed
weld84727732weld
wiled95231552wiled
wyled124611842wyled
yeld811423872yeld
ylem9217892ylem
zed135431172_zed

Search took 1 second 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.0802233637.5
2DLD Change Limit298723190.71641720.7
3Display Results3193190.0803987.5
 (SQL Overall)1786913190.876203985.2
 
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.