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 “forayed” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

398 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
forayed1436859(None) 
foraged124812271foraged
forayer13368941forayer
frayed135012161f_rayed
affrayed1842842affrayed
arrayed11117152arrayed
borated104116362borated
brayed124615782_brayed
drayed115911392_drayed
fayed126422152f__ayed
flayed134414052f_layed
foaled104515962fo_aled
foamed126014402fo_amed
forage104616992forage_
forager114412552forager
forages114217272forages
foramen12310532foramen
foray115023972foray__
forayers14277272forayers
forays124813002foray_s
forbye14427882forbye_
forced126316522for_ced
forded115020392for_ded
forged115519322for_ged
forked145217142for_ked
formed125021172for_med
foureyed1543662foureyed
framed125116522f_ramed
grayed115415642_grayed
hoorayed1544012hoorayed
okayed1434252_okayed
orated74221502_orated
prayed124815432_prayed
rayed95127502__rayed
sprayed13398902sprayed
strayed114513282strayed
abraded1138643abraded
aerated85322373aerated
affrayer1742693affrayer
allayed11138063allayed
arrased8149863arrased
arrayer10136703arrayer
assayed1135593assayed
aurated83817793aurated
bayed115423023__bayed
belayed133610083belayed
beraked144312433beraked
berated104422133berated
betrayed1436303betrayed
bewrayed1733933bewrayed
boarded113910503boarded
boated94221973bo_ated
bogeyed1435673bogeyed
boraces113716853boraces
borage93917013borage_
borages103917163borages
borane84620213borane_
boranes93720403boranes
borate85026153borate_
borates94823013borates
boraxes163511633boraxes
bored85034303bor__ed
borked135117293bor_ked
braced115420603_braced
braked135318693_braked
braved124817443_braved
brayer115315313_brayer
brazed184717083_brazed
cerated103922473cerated
clayed125013043_clayed
coaled95022703co_aled
coated94927033co_ated
coaxed165612513co_axed
cooeyed1346893cooeyed
corded105923353cor_ded
cored85044223cor__ed
corked135020783cor_ked
corned95224523cor_ned
cornfed1337383cornfed
corraded12128293corraded
coyed114623803co__yed
craned96121653_craned
craped116120523_craped
crated94827773_crated
craved125417773_craved
crazed184714453_crazed
croaked143710533croaked
curated104717583curated
decayed14309333decayed
defrayed1635403defrayed
delayed123310763delayed
derated93623503derated
doated84118183do_ated
donated93513863donated
draped105314363_draped
embayed1535443embayed
enraged93511783enraged
erased74816753_erased
essayed1134013essayed
estrayed1236393estrayed
faced117727653f__aced
faded105025243f__aded
faked135225483f__aked
famed115928343f__amed
farad95720673fara__d
farced125216533far_ced
farded114518953far_ded
fared95842343f__ared
farmed125117653far_med
farted105121783far_ted
fated95632133f__ated
faxed166220533f__axed
fazed186222963f__azed
feared106320433f_eared
feased105718713f_eased
feazed195112633f_eazed
fedayee1445513fedayee
ferried113411523ferried
feruled11318413feruled
fired94829743fir__ed
firmed125411883fir_med
fixated1835533fixated
flaked144715653f_laked
flamed124618973f_lamed
flared105317603f_lared
flawed134712723f_lawed
flayer124713563f_layer
fleyed13408813f_leyed
floated113312703floated
florae94713883flora_e_
floreated1346573floreated
floriated1347023floriated
foamer114714313fo_amer
fobbed144112613fo_bbed
focused13166413focused
fogged125518373fo_gged
foiled104618403fo_iled
foined105915013fo_ined
foisted113210603foisted
folate93320393folate_
folates103218453folates
folded114212793fo_lded
foliaged1344673foliaged
foliated1249913foliated
folioed1138033folioed
fonded115717043fo_nded
fondled12399423fondled
fondued12466363fondued
fooled104317823fo_oled
footed104418623fo_oted
footled113610763footled
foozled20346893foozled
fopped144012673fo_pped
fora75937393fora___
foragers12349623foragers
foram105124933fora__m
foramens1337823foramens
forams115115913fora_ms
foraying1537433foraying
forbad122710503for_bad
forbade13259103forbade_
forbare122310513forbare_
forbid123312433for_bid
forbode13257963forbode
forboded15215353forboded
forby135317673forby__
force105324273for_ce_
forcer114917343for_cer
forces114422133for_ces
ford86835493for___d
fordid113512053for_did
fordoes11311963fordoes
fore78351473for__e_
forearmed1544863forearmed
forebye1536353forebye_
foredated1447683foredated
foredid1238503foredid
foredo10510823for__edo
forefend1545603forefend
forehead1537893forehead
foreleg1137743foreleg
foremen12412923foremen
forenamed1545163forenamed
fores85847103for__es
foresee10414333foresee
forested12312463forested
forever1338953forever
foreyard1546423foreyard
forfend1435413forfend
forgave1435853forgave_
forge95126943for_ge_
forger104820763for_ger
forges105024263for_ges
forget106326393for_get
forgoer1137683forgoer
forgoes11311353forgoes
forker134717903for_ker
forkier144311583forkier
forky156119643forky__
formate123115093formate_
formates132814293formates
formatted1544883formatted
forme105225993for_me_
formee113919943for_mee
former114221403for_mer
formes114623713for_mes
formyl14276443formy_l
formyls15235703formyls
forrader1236133forrader
forsake1436533forsake_
forsaken1543353forsaken
forsaker1545103forsaker
forsakes1536893forsakes
forte86131463for_te_
fortes95327183for_tes
forties104323863forties
fortuned1285323fortuned
forty114824273forty__
forward1438293forward
forwarded1743943forwarded
fouled104315973fo_uled
founded124011423founded
foveated1536293foveated
fowled133914093fo_wled
foxed165115213fo__xed
foyer116416553fo__yer
fracted1339373f_racted
frae75330473f_ra_e_
fragged134010153f_ragged
frame105821803f_rame_
framer114817443f_ramer
frames115119863f_rames
franked153610053f_ranked
frapped15318853f_rapped
frater94520593f_rater
fraud939863f_ra_ud
fray105428903f_ray__
frays116920103f_ray_s
freaked15399703freaked
freed95223543f_r_eed
fried95322913f_r_ied
frized193510683f_rized
frocked17439333frocked
frogeyed1642783frogeyed
frogged13408493frogged
fronded12388863fronded
fronted114011273fronted
frosted113211873frosted
frothed14288783frothed
frowned14348833frowned
fryer115913433f_r_yer
furane94015493furane_
furanes103214863furanes
furcated1437593furcated
furled104717053fur_led
furnaced1443513furnaced
furred104514433fur_red
garaged1039253garaged
goaded94913713go_aded
goaled85014353go_aled
gored75227083gor__ed
gorged95016983gor_ged
gormed105013833gor_med
gowaned1235763gowaned
graced105217903_graced
graded94919553_graded
grated84523923_grated
graved114818813_graved
grayer106014543_grayer
grazed174115913_grazed
greyed114610603_greyed
groaned9259973groaned
gyrated12428413gyrated
hayed125822013__hayed
hoarded12368343hoarded
hoaxed17378873ho_axed
homaged1497413homaged
honeyed1437773honeyed
hoorahed1545093hoorahed
horded115420483hor_ded
horned105718703hor_ned
horsed105321083hor_sed
hoseyed1436953hoseyed
hurrayed1543043hurrayed
iodated9310023iodated
joyed164811833jo__yed
layed95127383__layed
loaded84616873lo_aded
loafed104011153lo_afed
loamed94414613lo_amed
loaned73816293lo_aned
lobated102610943lobated
located103114183located
lorded84916733lor_ded
lyrated11388473lyrated
mayed115522403__mayed
moaned94514173mo_aned
moated94819003mo_ated
moneyed1337493moneyed
morae75831193mora_e_
morale85220553morale_
morales93619403morales
moray105423793moray__
morays114613883moray_s
morphed1537133morphed
mortared1137213mortared
moseyed1336133moseyed
muraled10410823muraled
nonrated9310843nonrated
normed95014543nor_med
notated82713663notated
oared65030653_o_ared
obeyed1235823_obeyed
orad56031693_ora__d
orate55133303_orate_
orates64328613_orates
orbed85516193_or_bed
paraded114014263paraded
parlayed1435803parlayed
payed115925933__payed
phrased1387383phrased
pirated102515613pirated
played124815033_played
pomaded13377863pomaded
popeyed1535703popeyed
pored85234513por__ed
porked134717623por_ked
portaged12228463portaged
portaled11239203portaled
ported94223243por_ted
portrayed1564103portrayed
prated94924923_prated
prayer114815293_prayer
preyed125313193_preyed
prorated11513713prorated
raced87635313__raced
raged74829453__raged
raked105831423__raked
raped85334623__raped
rared65738323__rared
rased65033933__rased
rated65441383__rated
raved94931433__raved
raxed135622663__raxed
razed155027983__razed
relayed113212753relayed
roamed95215093ro_amed
roared75015393ro_ared
rotated82715293rotated
sayed96127143__sayed
scraped124313133scraped
slayed104716223_slayed
soaked114717593so_aked
soaped95817973so_aped
soared74324293so_ared
sofabed1334333sofabed
solaced102911063solaced
solated83618023solated
sorbed94916513sor_bed
sored66141783sor__ed
sorned74820043sor_ned
sorted74523713sor_ted
sortied83314093sortied
spayed124213613_spayed
splayed13357813splayed
sprayer12369043sprayer
stayed104817273_stayed
storeyed1234643storeyed
strafed114413323strafed
straked125415343straked
strawed114813613strawed
strayer104312493strayer
stroyed114110863stroyed
swayed133510263_swayed
thrawed1435583thrawed
togaed84711343toga_ed
togated94410663togated
torched133511353torched
torqued17224893torqued
totaled839693totaled
toyed96019803to__yed
traced94821583_traced
traded85717683_traded
troaked12438253troaked
unraked122914013unraked
unrated82621553unrated
unrazed172511453unrazed
uprated103213323uprated
voyaged1533513voyaged
woaded115211603wo_aded
womaned1337213womaned
worded114316623wor_ded
worked145314703wor_ked
wormed124314303wor_med
worried11308693worried
worsted1138013worsted
worthed1437873worthed
zonated173310533zonated

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273987.45317983.0
3Display Results3983980.2801421.4
 (SQL Overall)1786913987.88922650.7
 
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.