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

175 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
flied9651943(None) 
filed95331901filed
fled85429771fl_ed
flier86023401flier
flies85630711flies
flited104616581flited
flued95021251flued
fried95322911fried
lied55838091_lied
plied85118591plied
ailed66240282ailed
alien56425582alien
alined75221402alined
aliped95414282aliped
allied74217152allied
belied95022162belied
bled75729312bl_ed
bleed85019802bleed
blind86319322blind
blued84520322blued
clued84917682clued
cried84624282cried
died66137852_died
dried75321382dried
elide64922642elide
elided84814672elided
faced117727652faced
faded105025242faded
failed105421602failed
faired105915772faired
faked135225482faked
famed115928342famed
fared95842342fared
fated95632132fated
faxed166220532faxed
fayed126422152fayed
fazed186222962fazed
fed76548352f__ed
feed84538902f_eed
felid94717172feli_d
felled103720302felled
felted103714652felted
feted94420932feted
feued94715662feued
fid76847682f_i_d
fie67152442f_ie_
fief107331362f_ief
field95015322f_ield
fiend95312982f_iend
fifed125115972fifed
file75446642file_
filer85433002filer
files85441272files
filet85540162filet
filled104922262filled
filmed124610362filmed
find87532602f_ind
fined94930502fined
fired94829742fired
fixed165416952fixed
flailed1137302flailed
flaked144715652flaked
flamed124618972flamed
flared105317602flared
flawed134712722flawed
flayed134414052flayed
flea75628492fl_ea
flee76238792fl_ee
fleer86020772fleer
flees85828752flees
fleet85932332fleet
flew105824252fl_ew
flex146123472fl_ex
flexed17419092flexed
fley106626852fl_ey
fleyed13408812fleyed
flic96223732fli_c
flick145017212flick
flicked174610672flicked
flics105418362flics
fliers94417192fliers
fliest94718432fliest
fling97023512fling
flint87333502flint
flinted114411892flinted
flip96324262fli_p
flipped15358512flipped
flips105117742flips
flir76422202fli_r
flirs85518932flirs
flirt87424752flirt
flirted11428672flirted
flit76539272fli_t
flite85424962flite
flites95122442flites
flits85625222flits
flitted114011642flitted
floe76129772floe_
floes85528142floes
flood95215602flood
flowed133513762flowed
flue75329852flue_
flues84626922flues
fluid94013962fluid
fluked145112092fluked
flumed124915262flumed
fluted104917162fluted
fluxed17509672fluxed
flyer114916252flyer
flyted13378772flyted
foiled104618402foiled
foined105915012foined
folded114212792folded
folioed1138032folioed
foxed165115212foxed
freed95223542freed
friend10388932friend
frier85225842frier
fries85535602fries
frized193510682frized
fulled103820652fulled
fumed116118822fumed
fused94820442fused
fuzed185415252fuzed
gied64631982_gied
gled65631142gl_ed
gleed75320572gleed
glide74521592glide
glided94513902glided
glimed105312282glimed
glued75118362glued
hied85434042_hied
iliad64613462iliad
ivied94710522ivied
led46254552_l_ed
lid47453512_li_d
lie38264522_lie_
lief76036992_lief
lien45339802_lien
lier45942462_lier
lies46454192_lies
lieu46534362_lieu
liked104523812_liked
lilied73913212lilied
limed85426802_limed
lined64934642_lined
lived95523722_lived
oiled64429472oiled
pied75035362_pied
piled85232992piled
pled75231432pl_ed
plie65127392plie_
plier75221282plier
plies74526512plies
pried84426862pried
relied74926232relied
riled65833252riled
shied96125492shied
skied104417752skied
sled55334372sl_ed
sliced94416312sliced
slid55828982sli_d
slide64725412slide
slier54827242slier
slimed94915122slimed
sliped95417062sliped
slued64220512slued
spied85427712spied
stied65723032stied
tied55535212_tied
tiled64832942tiled
tried65026912tried
vied86328632_vied
wiled95231552wiled
wried95518562wried

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 Filter178691538000.296603685.8
2DLD Change Limit538001751.56034487.2
3Display Results1751750.0463804.3
 (SQL Overall)1786911751.90293949.0
 
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.