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

276 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
narrow926914(None) 
arrow83414881_arrow
barrow114512761barrow
farrow12309971farrow
harrow122610771harrow
marrow112812601marrow
narrows10258841narrows
yarrow12287931yarrow
arrows92813482_arrows
arrowy12288272_arrowy
barlow112911422barlow
barrows123411682barrows
borrow114310722borrow
burrow114610802burrow
carrom10513402carrom
carrot8423122carrot
farrows13259782farrows
furrow12427742furrow
garron73113492garron
harrows132611032harrows
karroo10410012karroo
marron83717542marron
marrows122911812marrows
marrowy15236082marrowy
morrow113510092morrow
narco76718242narco_
narcos86714202narcos
narrowed1235202narrowed
narrower1145062narrower
narrowly1442902narrowly
natron64116022natron
parrot8320662parrot
sorrow9339442sorrow
sparrow1234262sparrow
yarrows13277852yarrows
aarrgh10786303aarrgh
aero45435343_aero_
aglow94711963_aglow
allow85420663_allow
alow75328593_a_low
andro6314163andro_
andros7313303andros
anyhow1544103anyhow
apron7318833_apron
arbor74818113_arbor
arco68331543_arco_
ardor64617863_ardor
argol65317263_argol
argon65520593_argon
argot67728643_argot
armor75118053_armor
arras55626133_arras
array86317143_array
arris56824683_arris
arroba898663_arroba
arrowed1148103_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
fallow124713853fallow
faro76136923fa_ro_
faros85532023fa_ros
farrowed1545283farrowed
frow106425053__frow
furrows13327793furrows
furrowy16384473furrowy
garcon92912483garcon
garred85217403garred
garret74426553garret
garrons82713463garrons
garrote8510103garrote
gnarr64810693gnarr__
gnarred9327003gnarred
gnarrs7407663gnarr_s
grow86127303__grow
hadron102913753hadron
hallow124818323hallow
harbor11410723harbor
harlot94422803harlot
harrowed1556263harrowed
harrower1446363harrower
harry115322953harr_y
haymow1773683haymow
horror988723horror
interrow1147133interrow
jargon1448823jargon
jarrah1636683jarrah
jarred144613253jarred
karoo92519583ka_roo
karoos102415803karoos
karroos1139313karroos
knarred12266003knarred
knarry1334613knarr_y
ladron73413323ladron
lardon74415063lardon
largo65319783largo_
largos74815063largos
larrup835713larrup
macro94718173macro_
macron103615673macron
macros104017013macros
mallow114014743mallow
marmot10318743marmot
maroon83118203maroon
marram10313883marram
marred95421043marred
marrer83716673marrer
marrons93216973marrons
marrowed1445973marrowed
marry104821693marr_y
matron83918313matron
mirror848003mirror
morro73216953morro_
morros83714673morros
morrows12318723morrows
nabob93913733na_bob
nacho105414383nacho_
nachos115014183nachos
nacre75715363nacr_e
nacred95212493nacred
nacres85614453nacres
naira5314743nair_a
nairas6312773nairas
nairu5413813nair_u
nairus639143nairus
naoi46024633na__oi
naos47429733na__os
narc67127953na_r_c
narcoma1145823narcoma
narcose95910383narcose
narcs76122023na_rcs
nard56634453na_r_d
nards65928463na_rds
nares55544153na_res
narial6317953narial
naric76824173na_ric
narine63422553narine
naris55735293na_ris
nark85230063na_r_k
narked114116743narked
narks96026033na_rks
narky126017803na_rky
narrate7313493narrate
narrator847563narrator
narrowest1244283narrowest
narrowing1345603narrowing
narrowish1543743narrowish
narwal938943narwal
nary76931223na_r_y
nasion63914083nasion
nation64322803nation
natrons73215663natrons
naw66346493na___w
nerol51017813n_erol
neuron6310373neuron
nimrod934873nimrod
nitro54914353nitro_
nitros64214123nitros
nohow1137293n_ohow
now65950193n___ow
outrow9311173outrow
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
terror63811723terror
throw118719733_throw
trow78031423__trow
upgrow1234273upgrow
vagrom1235943vagrom
varoom11411413varoom
vrow105817473__vrow
wallow123913513wallow
warred104019843warred
warren95012853warren
warrior1045363warrior
warsaw1236193warsaw

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 Filter1786911127160.1701051123.5
2DLD Change Limit1127162767.19015676.8
3Display Results2762760.0932967.7
 (SQL Overall)1786912767.45323975.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.