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

249 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
yarrow1228793(None) 
arrow83414881_arrow
barrow114512761barrow
farrow12309971farrow
harrow122610771harrow
marrow112812601marrow
narrow9269141narrow
yarrows13277851yarrows
arrows92813482_arrows
arrowy12288272_arrowy
barlow112911422barlow
barrows123411682barrows
borrow114310722borrow
burrow114610802burrow
carrom10513402carrom
carrot8423122carrot
farrows13259782farrows
furrow12427742furrow
garron73113492garron
harrows132611032harrows
karroo10410012karroo
marron83717542marron
marrows122911822marrows
marrowy15236082marrowy
morrow113510092morrow
narrows10258842narrows
parrot8320662parrot
sorrow9339442sorrow
sparrow1234262sparrow
aarrgh10786303aarrgh
aero45435343_aero_
aglow94711973_aglow
allow85420663_allow
alow75328593_a_low
apron7318833_apron
arbor74818113_arbor
arco68331543_arco_
ardor64617863_ardor
argol65317263_argol
argon65520593_argon
argot67728653_argot
armor75118053_armor
arras55626133_arras
array86317143_array
arris56824683_arris
arroba898663_arroba
arrowed1148113_arrowed
arroyo936963_arroyo
arson55118833_arson
arvo76023433_arvo_
arvos86015663_arvos
avow107816463_a_vow
barhop13319643barhop
barlows12259973barlows
baron78131243ba_ron
barre75929543barr_e
barred95725793barred
barrel84517873barrel
barren85317613barren
barres84427543barres
barret84930483barret
barrio8312573barrio
barrios9310773barrios
barroom1139373barroom
baryon111211613baryon
borrows12349253borrows
brow97228443__brow
burro75018493burro_
burros85114993burros
burrows12399093burrows
cahow135110943ca_how
callow114714663callow
carbo94923843carbo_
carbon104919043carbon
carbos105122263carbos
carboy134914183carboy
cardon94120853cardon
cargo85322073cargo_
cargos94619183cargos
carhop133610763carhop
carob95325223ca_rob
carol75128613ca_rol
carom95025563ca_rom
carr65434703carr__
carrel84718633carrel
carrion9312673carrion
carroch1437093carroch
carroms11512403carroms
carrots9714623carrots
carroty1248943carroty
carrs75730853carr_s
carry105823783carr_y
carryon1237033carryon
carton84522663carton
cartop104213563cartop
charro114212953charro_
charros124312143charros
cornrow1245603cornrow
crow96428133__crow
dacron94310693dacron
eardrop1065223eardrop
error53712233_error
escrow1135913escrow
eyebrow1542863eyebrow
fallow124713853fallow
faro76136923fa_ro_
faros85532023fa_ros
farrowed1545283farrowed
frow106425053__frow
furrows13327793furrows
furrowy16384473furrowy
garcon92912483garcon
garred85217403garred
garret74426553garret
garrons82713463garrons
garrote8510103garrote
grow86127303__grow
hadron102913753hadron
hallow124818323hallow
harbor11410723harbor
harlot94422803harlot
harrowed1556263harrowed
harrower1446363harrower
harry115322953harr_y
haymow1773683haymow
horror988723horror
jargon1448823jargon
jarrah1636683jarrah
jarred144613253jarred
karoo92519583ka_roo
karoos102415803karoos
karroos1139313karroos
ladron73413323ladron
lardon74415063lardon
largo65319783largo_
largos74815063largos
larrup835713larrup
macro94718173macro_
macron103615673macron
macros104017013macros
mallow114014743mallow
marmot10318743marmot
maroon83118203maroon
marram10313883marram
marred95421043marred
marrer83716673marrer
marrons93216973marrons
marrowed1445973marrowed
marry104821693marr_y
matron83918313matron
mirror848003mirror
morro73216953morro_
morros83714673morros
morrows12318723morrows
narco76718243narco_
narcos86714203narcos
narrowed1235203narrowed
narrower1145063narrower
narrowly1442903narrowly
natron64116023natron
outrow9311183outrow
pardon94618733pardon
pareo74632603pareo_
pareos87023773pareos
pargo86723723pargo_
pargos95719043pargos
parlor8312673parlor
parol74826273pa_rol
parr65731153parr__
parral85517533parral
parred95024073parred
parrel84515983parrel
parrots9312743parrots
parroty1247863parroty
parrs75928673parr_s
parry105323753parr_y
parson83817903parson
parton84720993parton
parvo107719183parvo_
parvos116614753parvos
patrol83213023patrol
patron84018043patron
perron83216623perron
prow97030383__prow
pyrrol1136273pyrrol
ramrod936833ramrod
regrow10309883regrow
row67453673___row
safrol937283safrol
sallow94315753sallow
sargo65424413sargo_
sargos74318273sargos
sarod65325873sa_rod
saros55238063sa_ros
sartor6313873sartor
serow86720443_serow
sorrows10278403sorrows
sparrows1344803sparrows
strow88920573_strow
tallow93714203tallow
tardo65321103tardo_
taro46846913ta_ro_
taroc75721643ta_roc
tarok97921073ta_rok
taros55640823ta_ros
tarot55943933ta_rot
tarpon82812803tarpon
tarre55825633tarr_e
tarred74720283tarred
tarres64723043tarres
tarry85422513tarr_y
terror63811733terror
throw118719733_throw
trow78031423__trow
upgrow1234273upgrow
vagrom1235943vagrom
varoom11411413varoom
vrow105817473__vrow
wallow123913513wallow
warred104019843warred
warren95012853warren
warrior1045363warrior
warsaw1236193warsaw
yahoo112911543ya_hoo
yahoos12209243yahoos
yaird96111913yair_d
yairds10448023yairds
yapok14468153ya_pok
yapon104613583ya_pon
yar67253833ya_r__
yard85633253ya_r_d
yarded114714023yarded
yarder103813973yarder
yards95324613ya_rds
yare75636943ya_r_e
yarely122810303yarely
yarer84321573ya_rer
yarest95018913yarest
yarn75230043ya_r_n
yarned105514023yarned
yarner93313063yarner
yarns85621793ya_rns
yaupon11345493yaupon
yaw97145153ya___w
yellow12429883yellow
yirr76513573yirr__
yirred10426963yirred
yirrs8469193yirr_s
yow96945293y___ow

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127162495.00022543.2
3Display Results2492490.0803112.5
 (SQL Overall)1786912495.20334343.8
 
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.