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

258 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
yellow1242988(None) 
bellow114213351bellow
fellow123712741fellow
mellow114112221mellow
yellows13329601yellows
yellowy16255691yellowy
allow85420662_allow
bellows124313302bellows
below104617192be_low
billow114111222billow
callow114714662callow
cello74919582cello_
cellos84517802cellos
elbow10117702_elbow
fallow124713852fallow
felloe93513922felloe
fellows134212432fellows
follow124010352follow
hallow124818322hallow
hello86522982hello_
hellos95321682hellos
hollow124212662hollow
jello126716272jello_
jellos134714282jellos
mallow114014742mallow
mellows123812232mellows
pillow113110572pillow
reflow12379652reflow
reglow10339402reglow
replow114210342replow
sallow94315752sallow
tallow93714202tallow
wallow123913512wallow
willow12369692willow
yell76028322yell__
yelled104116252yelled
yeller94214512yeller
yellowed15185742yellowed
yellower14186212yellower
yellowly17283622yellowly
yells85821942yell_s
aglow94711973_aglow
allod64418383_allod
allot54933873_allot
allows94517683_allows
alloy85519973_alloy
alow75328593__alow
ballon84117493ballon
ballot84624093ballot
barlow112911423barlow
beclog1136863beclog
beclown1435423beclown
bell66237183bell__
bellboy1445123bellboy
belle75827833bell_e
belled94626193belled
belles85325993belles
bellhop1445053bellhop
bellowed14158603bellowed
bellower13159063bellower
bells76432163bell_s
belly104625493bell_y
belon73924113be_lon
belows114614183be_lows
besnow1145713besnow
bestow1149463bestow
billon83713833billon
billows123611293billows
billowy15366903billowy
blow95827193__blow
bollox1548743bollox
byelaw1444253bye_law
cell65031723cell__
cella75420313cell_a
cellae84915933cellae
cellar84514983cellar
celled94420323celled
celli76717693cell_i
cells75428063cell_s
celom9515693ce_lom
collop107312313collop
declaw1266703declaw
dell56938203dell__
dells66630943dell_s
delly96023873dell_y
deploy1237583deploy
dollop9259363dollop
duello756783duello_
duellos845763duellos
elbows1196713_elbows
ell36735683_ell__
ells46431353_ell_s
embow1297563_embow
endow94510983_endow
enow77819873_e_now
eyebrow1542863eyebrow
fallows133713973fallows
fell76833073fell__
fella84918653fell_a
fellah124910773fellah
fellas95116963fellas
felled103720303felled
feller94419553feller
felloes104114383felloes
fellowed15136833fellowed
fellowly17264093fellowly
fells85327383fell_s
felly114922803fell_y
felon84619293fe_lon
fillo84319783fillo_
fillos94415083fillos
flow105924923__flow
follows13409923follows
gallon73715813gallon
gallop93311383gallop
gallows113513513gallows
gelled84718893gelled
glow85222523__glow
hallo85127553hallo_
halloa94918123halloa
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallows134417393hallows
helio85321193helio_
helios94816633helios
hell75637893hell__
hellbox1944983hellbox
helled104024703helled
heller93322513heller
hellion10311133hellion
helloed113512423helloed
helloes103717463helloes
hells85032043hell_s
helo75332853he_lo_
helos84928063he_los
helot85332683he_lot
hillo84721653hillo_
hilloa94713033hilloa
hillos94618893hillos
hollo84822163hollo_
holloa94914823holloa
holloo94415253holloo
hollos95320633hollos
hollows134412333hollows
hullo84417453hullo_
hulloa95011183hulloa
hulloo94511733hulloo
hullos94916293hullos
inflow1235293inflow
jell117125873jell__
jelled144916063jelled
jells125522163jell_s
jelly154218253jell_y
kelly124617023kell_y
kelson1038153kelson
lollop8238783lollop
low66051873___low
mallows123714323mallows
meadow1237403meadow
melilot9311083melilot
mell64935613mell__
melled95023023melled
mellowed14166923mellowed
mellower13167403mellower
mellowly16254003mellowly
mells75031333mell_s
melon73922083me_lon
melton8311553melton
meow95117883me__ow
merlon83012353merlon
merlot83217613merlot
nellie63614813nellie
nelly84618813nell_y
nelson638423nelson
niello636603niello_
niellos736143niellos
pallor8313673pallor
pellet83326553pellet
pelon74423213pe_lon
peplos101211543peplos
pillows122610123pillows
pillowy15316423pillowy
plow95923233__plow
reallot7312133reallot
reavow1235723reavow
reflew12389453reflew
reflown13316213reflown
reflows13258983reflows
reglows11288843reglows
regrow10309883regrow
relook104813743relook
replot83818593replot
replows12329703replows
reshow123111433reshow
resow88217243re_sow
sallows103915553sallows
sallowy13369343sallowy
seldom939413seldom
sell45840613sell__
selle54428313sell_e
seller63824603seller
selles64426983selles
selloff1345923selloff
sellout7313583sellout
sells55134433sell_s
serow86720443se_row
shallow13388873shallow
slow77729493__slow
swallow13355753swallow
tallol63612223tallol
tallows103313743tallows
tallowy13347633tallowy
teflon937453teflon
telco7511873telco_
telcos8710683telcos
tell44934703tell__
teller63519823teller
tells55828943tell_s
telly84920823tell_y
tellys9348843tellys
teloi54217383te_loi
telos55424523te_los
telson6310293telson
unmellow1342243unmellow
upflow1433523upflow
vellum1136773vellum
wallop113310293wallop
wallows133613533wallows
weblog1234223weblog
weldor10317653weldor
well75832043well__
welled103820213welled
wellie92814913wellie
wells85426193well_s
welly114620013well_y
willows13299753willows
willowy16276353willowy
yarrow12287933yarrow
yeelin939343yeelin
yeld811423873ye_l_d
yelk115320003ye_l_k
yelks126413623ye_lks
yellers103912953yellers
yelling113516703yelling
yellowest1554013yellowest
yellowfin1851903yellowfin
yellowing1655073yellowing
yellowish1843323yellowish
yelp95621353ye_l_p
yelped12439363yelped
yelper11458783yelper
yelps105712993ye_lps
yew96436293ye___w
yill75628973yill__
yills83921553yill_s
yow96945293y___ow
zealot15313473zealot

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.376475242.0
2DLD Change Limit1127162585.07622205.7
3Display Results2582580.0803225.0
 (SQL Overall)1786912585.53232301.3
 
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.