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

224 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
yellows1332960(None) 
bellows124313301bellows
fellows134212431fellows
mellows123812231mellows
yellow12429881yellow_
yellowy16255691yellowy
allows94517682_allows
bellow114213352bellow_
belows114614182be_lows
billows123611292billows
cellos84517802cello_s
elbows1196712_elbows
fallows133713972fallows
felloes104114382felloes
fellow123712742fellow_
follows13409922follows
gallows113513512gallows
hallows134417392hallows
helloes103717462helloes
hellos95321682hello_s
hollows134412332hollows
jellos134714282jello_s
mallows123714322mallows
mellow114112222mellow_
pillows122610122pillows
reflows13258982reflows
reglows11288842reglows
replows12329702replows
sallows103915552sallows
tallows103313742tallows
wallows133613532wallows
willows13299752willows
yellers103912952yellers
yellowed15185742yellowed
yellower14186212yellower
yellowest1554012yellowest
yellowish1843322yellowish
yellowly17283622yellowly
yells85821942yell__s
allods73615083_allods
allots64019173_allots
allow85420663_allow_
alloys94014563_alloys
ballons93916963ballons
ballots94116033ballots
barlows12259973barlows
beclogs1237073beclogs
beclown1435423beclown
beclowns1544683beclowns
bellboys1544523bellboys
belles85325993bell_es
bellhops1544873bellhops
bellies94023723bellies
bellowed14158603bellowed
bellower13159063bellower
bellowers14177623bellowers
bells76432163bell__s
belons84119413be_lons
below104617193be_low_
besnows1245153besnows
bestows1248863bestows
billons93013363billons
billow114111223billow_
billowy15366903billowy
blows105423833__blows
bullous9311663bullous
byelaws1533263bye_laws
callous93516603callous
callow114714663callow_
cellars93713693cellars
cello74919583cello__
cells75428063cell__s
celoms10412123ce_loms
collops112611753collops
declaws1336253declaws
dellies83622213dellies
dells66630943dell__s
deploys1336523deploys
dollops10287963dollops
duellos845763duello_s
elbow10117703_elbow_
ells46431353_ell__s
embows1396823_embows
endows104610423_endows
enows85115493_e_nows
eyebrows1642453eyebrows
fallow124713853fallow_
fellahs13428393fellahs
fellas95116963fell_as
fellers104117543fellers
fellies104119743fellies
felloe93513923fello_e
fellowed15136833fellowed
fellowly17264093fellowly
fells85327383fell__s
felons93615763fe_lons
fillos94415083fillo_s
flows115822363__flows
follow124010353follow_
gallons83015953gallons
gallops103211653gallops
gallous82813953gallous
glows95518033__glows
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hallo_s
hallow124818323hallow_
helios94816633helio_s
hellers103619833hellers
hellions11310023hellions
hello86522983hello__
helloed113512423helloed
hells85032043hell__s
helos84928063he_lo_s
helots95217703he_lots
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollow124212663hollow_
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
inflows1335523inflows
jealous1438093jealous
jellies143816533jellies
jello126716273jello__
jells125522163jell__s
kellies113516853kellies
kelsons1137323kelsons
lollops9227443lollops
lows75843013___lows
mallow114014743mallow_
meadows1337333meadows
melilots1046553melilots
mellowed14166923mellowed
mellower13167403mellower
mellowest1445123mellowest
mellowly16254003mellowly
mells75031333mell__s
melons84117713me_lons
meltons9410923meltons
meows104612683me__ows
merlons93311273merlons
merlots92710123merlots
nellies73418723nellies
nelsons738003nelsons
niellos736143niello_s
pallors9314363pallors
pellets94014783pellets
peplos101211543peplo_s
pillow113110573pillow_
pillowy15316423pillowy
plows105419903__plows
reallots837993reallots
reavows1335273reavows
reflow12379653reflow_
reflown13316213reflown
regloss8218023regloss
reglow10339403reglow_
regrows11269153regrows
relooks114010723relooks
replots93412633replots
replow114210343replow_
reshows132510453reshows
resows93915353re_sows
sallow94315753sallow_
sallowy13369343sallowy
sellers73721313sellers
selles64426983sell_es
selloff1345923selloff
selloffs1443633selloffs
sellout7313583sellout
sellouts837493sellouts
sells55134433sell__s
serows96016393se_rows
shallows14388863shallows
slows85323463__slows
swallows14295893swallows
tallols73311363tallols
tallow93714203tallow_
tallowy13347633tallowy
teflons1036543teflons
telcos8710683telco_s
tellers73717593tellers
tellies73820503tellies
tells55828943tell__s
tellys9348843tell_ys
telos55424523te_lo_s
telsons739213telsons
upflows1543513upflows
vellums1235293vellums
villous102810023villous
wallops123410413wallops
wallow123913513wallow_
weblogs1334223weblogs
weldors11238003weldors
wellies103719073wellies
wells85426193well__s
willow12369693willow_
willowy16276353willowy
yarrows13277853yarrows
yeelins1038813yeelins
yelks126413623ye_l_ks
yell76028323yell___
yelled104116253yell_ed
yeller94214513yell_er
yelling113516703yelling
yellowfin1851903yellowfin
yellowfins1951923yellowfins
yellowing1655073yellowing
yellowlegs1751473yellowlegs
yelpers12348203yelpers
yelps105712993ye_l_ps
yews105323963ye___ws
yills83921553yill__s
yows106433123y___ows
zealots1636763zealots
zealous1637813zealous

Search took 7 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.1431249587.4
2DLD Change Limit1340272246.07622058.4
3Display Results2242240.0932408.6
 (SQL Overall)1786912246.31228309.7
 
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.