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

203 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
fried9532291(None) 
cried84624281cried
dried75321381dried
fired94829741fired
flied96519431flied
freed95223541freed
friend10388931friend
frier85225841frier
fries85535601fries
frized193510681frized
pried84426861pried
tried65026911tried
wried95518561wried
aeried74221862aeried
aired66032922aired
arced88224162arced
arid57642712ari_d
ariel55228972ariel
ariled75620322ariled
armed86324432armed
bred75130972br_ed
breed85526692breed
bribed115312842bribed
bride86425532bride
brie65837902brie_
brief105422602brief
brier74527402brier
bries74942152bries
brined95118412brined
buried94822372buried
caried94528692caried
cred76530882cr_ed
creed85727392creed
crier74724462crier
cries75438402cries
died66137852_died
dreed75222842dreed
drier64423962drier
dries64733672dries
erred65915672erred
faced117727652faced
faded105025242faded
failed105421602failed
faired105915772faired
faked135225482faked
famed115928342famed
farced125216532farced
farded114518952farded
fared95842342fared
farmed125117652farmed
farted105121782farted
fated95632132fated
faxed166220532faxed
fayed126422152fayed
fazed186222962fazed
fed76548352f__ed
feed84538902f_eed
ferried113411522ferried
feted94420932feted
feued94715662feued
fid76847682f_i_d
fie67152442f_ie_
fief107331362f_ief
field95015322f_ield
fiend95312982f_iend
fifed125115972fifed
filed95331902filed
find87532602f_ind
fined94930502fined
fire76245592fire_
firer811229252firer
fires85740752fires
firmed125411882firmed
fixed165416952fixed
fled85429772f_led
flier86023402flier
flies85630712flies
flited104616582flited
flued95021252flued
foiled104618402foiled
foined105915012foined
forced126316522forced
forded115020392forded
forged115519322forged
forked145217142forked
formed125021172formed
foxed165115212foxed
frae75330472frae_
framed125116522framed
fraud939862fraud
frayed135012162frayed
free75940182fr_ee
freer86021242freer
frees86131392frees
fremd115010322fremd
fret75845042fr_et
friar85414272friar
friends11396742friends
friers94718932friers
frieze18378142frieze
frig85424502fri_g
friges104116482friges
frigged13439052frigged
frigid1136922frigid
frigs96019272frigs
frill84917562frill
frilled113911602frilled
fringed123611522fringed
frise85322452frise
frisee94217992frisee
frises94124272frises
frisk125312372frisk
frisked15478822frisked
frit77044472fri_t
frites94922482frites
frith115922032frith
frits86129102frits
fritt86129412fritt
fritted113611332fritted
fritz176020772fritz
friz166324342fri_z
frizer184011282frizer
frizes184015462frizes
frizz165512622frizz
frizzed19375972frizzed
froe75329992froe_
froes86126692froes
frond95316342frond
fruited11389092fruited
fryer115913432fryer
fumed116118822fumed
furies95126372furies
furled104717052furled
furred104514432furred
fused94820442fused
fuzed185415252fuzed
gied64631982_gied
greed75125692greed
grid65829612gri_d
gride75223582gride
grided95117042grided
grief95319782grief
grimed104714092grimed
grind75917562grind
griped104114712griped
hied85434042_hied
hired95226262hired
ired55131872ir_ed
irid55927172iri_d
irised73913152irised
irked104510922irked
ivied94710522ivied
juried144212442juried
lied55838092_lied
mired85729222mired
orbed85516192orbed
oriel54920422oriel
pied75035362_pied
plied85118592plied
preed85128122preed
priced115018882priced
pride84724732pride
prided103618032prided
prier75027762prier
pries74339532pries
primed115118912primed
prised94322202prised
prized184415392prized
red46755802_r_ed
reed55549622_reed
refried113513872refried
riced85825542_riced
rid46754622_ri_d
ride55945122_ride
riel46432382_riel
riled65833252_riled
rimed84826372_rimed
rind56535602_rind
riped85226432_riped
rived94825612_rived
rued55729792_rued
scried95817302scried
shied96125492shied
sired66134282sired
skied104417752skied
spied85427712spied
stied65723032stied
tied55535212_tied
tired65228902tired
treed65626732treed
triad65217722triad
triced95518672triced
trier54328532trier
tries55742812tries
trined74920712trined
trued65117692trued
urged75316032urged
urped84615282urped
varied104817862varied
vied86328632_vied
wired95327642wired
wrier84521752wrier
wries85827742wries

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.313570897.8
2DLD Change Limit538002031.37339184.3
3Display Results2032030.0633222.2
 (SQL Overall)1786912031.749102167.5
 
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.