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

393 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
fared9584234(None) 
bared85144481bared
cared86050091cared
dared75935011dared
eared65139501eared
faced117727651faced
faded105025241faded
faired105915771faired
faked135225481faked
famed115928341famed
farad95720671farad
farced125216531farced
fard85639061far_d
farded114518951farded
fare76354461fare_
farer86733141farer
fares85852871fares
farmed125117651farmed
farted105121781farted
fated95632131fated
faxed166220531faxed
fayed126422151fayed
fazed186222961fazed
feared106320431feared
fired94829741fired
flared105317601flared
hared95742181hared
oared65030651oared
pared86946761pared
rared65738321rared
tared69340051tared
wared96339871wared
aahed917816442aahed
abed79734132_abed
aced79540882_aced
acred87126352acred
afeared1176832afeared
aged67334252_aged
ahed89536252_ahed
aired66032922aired
aped78538152_aped
arced88224162_arced
are37874572_are_
area45843392_area
ares45871022_ares
arid57642712_arid
armed86324432_armed
awed88436032_awed
axed128829612_axed
baaed85218162baaed
baked126130772baked
baled85436442baled
baned85436352baned
barbed115121312barbed
bard75648862bar_d
barde85330772barde
barded105426422barded
bare65460522bare_
barer74535802barer
bares75457132bares
barfed125416382barfed
barged105822642barged
barked135027312barked
barned95623582barned
barred95725792barred
based85331582based
bated85935532bated
bayed115423022bayed
blared95018242blared
bored85034302bored
bred75130972_bred
caged95426362caged
caked126128622caked
caned85838092caned
caped104931802caped
card710245872car_d
carded105424902carded
care66968372care_
carer74942332carer
cares77369182cares
caret75360562caret
carex144822292carex
caried94528692caried
carked134024822carked
carped115923762carped
carted98631442carted
carved124320852carved
cased86032412cased
caved116227562caved
cawed116627062cawed
cered85227442cered
chared125423692chared
cored85044222cored
cred76530882_cred
cured85932132cured
dare55848862dare_
darer65230792darer
dares66146702dares
darked123919632darked
darned85018482darned
darted84620922darted
dated75530992dated
dawed106222812dawed
dazed165919362dazed
dured75025402dured
earned74818332earned
eased65430402eased
eaved95924502eaved
erred65915672erred
fabled124216382fabled
face96140122face_
facer105525052facer
faces106439432faces
facet106038522facet
fad77452412fa__d
fade85736342fade_
fader94421512fader
fades94932862fades
fadged124712352fadged
faery116015482faery
fagged124717702fagged
failed105421602failed
fairer95212062fairer
fake115534942fake_
faker124824592faker
fakes126032482fakes
fakey155515422fakey
fame95639392fame_
fames105735922fames
fane75343562fane_
fanes84639892fanes
fanged114318222fanged
fanned104117472fanned
far67762602far__
farads104713272farads
farce104925322farce
farcer115016082farcer
farces115223322farces
farci105919312farci
farcy135217092farcy
fardel104712592fardel
fards96629842fards
farers95924052farers
farfel124310432farfel
farl76338552far_l
farle86929242farle
farles96025782farles
farls85731112farls
farm95934532far_m
farmer115017372farmer
farms106324952farms
faro76136922far_o
faros85532022faros
fart76860562far_t
farts88336842farts
fashed136720252fashed
fasted105320952fasted
fate75444282fate_
fates85139232fates
fatted105419842fatted
fauld95214492fauld
fave105532962fave_
faves115331422faves
favored1455982favored
fawned134910422fawned
faxes155726652faxes
faze165630042faze_
fazes175527212fazes
fearer94820182fearer
feased105718712feased
feazed195112632feazed
fed76548352f__ed
feed84538902f_eed
fere76342232fere_
feres86038182feres
feted94420932feted
feued94715662feued
fifed125115972fifed
filed95331902filed
fined94930502fined
fire76245592fire_
firer811229252firer
fires85740752fires
firmed125411882firmed
fixed165416952fixed
flaked144715652flaked
flamed124618972flamed
flare84823632flare_
flares94521702flares
flawed134712722flawed
flayed134414052flayed
fled85429772f_led
flied96519432flied
flued95021252flued
foaled104515962foaled
foamed126014402foamed
forced126316522forced
ford86835492for_d
forded115020392forded
fore78351472fore_
foredo10510822foredo
fores85847102fores
forged115519322forged
forked145217142forked
formed125021172formed
foxed165115212foxed
frae75330472frae_
framed125116522framed
fraud939862fraud
frayed135012162frayed
free75940182f_ree
freed95223542freed
fremd115010322f_remd
fret75845042f_ret
fried95322912fried
fumed116118822fumed
furled104717052furled
furred104514432furred
fused94820442fused
fuzed185415252fuzed
gaed66031512ga_ed
gaged85522312gaged
gamed95126392gamed
gaped96123532gaped
garbed104815662garbed
garred85217402garred
gated75329772gated
gazed165520332gazed
geared85317742geared
glared84715192glared
gored75227082gored
gyred105114092gyred
haded105227622haded
haed86338582ha_ed
haired105117172haired
haled95335822haled
hard85443502har_d
hare76255732hare_
harem104924452harem
hares86255542hares
harked145422552harked
harmed125218832harmed
harped124418402harped
hated95734022hated
hatred104814332hatred
hawed126025422hawed
hayed125822012hayed
hazed185222202hazed
hired95226262hired
ired55131872_ired
jaded144417032jaded
japed156217632japed
jarred144613252jarred
jawed165517372jawed
laced87132642laced
laded74232612laded
laired75216812laired
laked105731122laked
lamed85235292lamed
lard56742002lar_d
larded84319092larded
laree56036292laree
lares54852632lares
larked114519472larked
lased65132342lased
lated65240672lated
laved95028592laved
lawed96028322lawed
layed95127382layed
lazed154925842lazed
lured65427492lured
maced108528692maced
maned86634092maned
mare64759322mare_
mares76457632mares
marked133921622marked
marled95523162marled
marred95421042marred
marted94425212marted
mated85537782mated
mawed115824742mawed
maxed155821192maxed
mayed115522402mayed
mazed175523872mazed
mired85729222mired
mured85726702mured
nacred95212492nacred
naked105320852naked
naled65525052naled
named85223062named
nard56634452nar_d
nares55544152nares
narked114116742narked
neared75119802neared
paced106931682paced
paged95926782paged
paired95017522paired
paled85538722paled
paned85437182paned
pard76441322par_d
pare66760842pare_
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parged104922032parged
parked134425132parked
parled94626272parled
parred95024072parred
parsed96323892parsed
parted94228682parted
pated85237842pated
paved115525262paved
pawed115725612pawed
payed115925932payed
pored85234512pored
raced87635312raced
raged74829452raged
raked105831422raked
raped85334622raped
rare45348432rare_
rarer54731702rarer
rares55247442rares
rased65033932rased
rated65441382rated
raved94931432raved
raxed135622662raxed
rayed95127502rayed
razed155027982razed
reared75930012reared
red46755802__red
roared75015392roared
sabed86526812sabed
sabred95916532sabred
sacred94917102sacred
saned65636272saned
sard55344242sar_d
saree55044662saree
sarod65325872sarod
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
scared95227292scared
seared75232842seared
sered65737292sered
shared105829062shared
shred98125612shred
sired66134282sired
snared74824552snared
soared74324292soared
sored66141782sored
spared95427482spared
stared75429872stared
tamed85528512tamed
taped85327422taped
tare45957622tare_
tares57456562tares
tarred74720282tarred
tarted74923372tarted
tawed95926192tawed
taxed135620292taxed
teared75722152teared
tired65228902tired
tyred95816432tyred
vaned94622422vaned
varied104817862varied
varved134110602varved
waded106024752waded
waged104822782waged
waired106015832waired
waked135626752waked
waled94330992waled
waned95831782waned
ward86542252war_d
warded115021042warded
ware76254722ware_
wares88250582wares
warked144421212warked
warmed124516892warmed
warned104018912warned
warped124816412warped
warred104019842warred
warted104223232warted
waved125223582waved
waxed166018482waxed
wired95327642wired
yard85633252yar_d
yarded114714022yarded
yare75636942yare_
yarer84321572yarer
yarned105514022yarned
yawed126022452yawed

Search took 5 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.186960704.3
2DLD Change Limit538003934.18612852.4
3Display Results3933930.2201786.4
 (SQL Overall)1786913934.59238913.5
 
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.