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

449 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
valleys1340748(None) 
alleys95113301_alleys
galleys11369711galleys
valley124311601valley_
volleys13316641volleys
allays94313742_allays
allees64521482_allees
alley85721672_alley_
alloys94014562_alloys
baileys12388932baileys
ballers94421012ballers
ballets93719512ballets
barleys125011842barleys
callees94117782callees
callers94221962callers
callets93821702callets
dalles74222062dalle_s
fallers103917992fallers
gallets83517402gallets
galley104215452galley_
gulleys11438522gulleys
hallels103310132hallels
mallees93315972mallees
mallets93318492mallets
malleus92911312malleus
mulleys12299202mulleys
pallets93919302pallets
parleys125212372parleys
pulleys12399142pulleys
rallyes10348552rallyes
sallets73719652sallets
vales85434262va_le_s
valets93715622va_lets
valleyed1534012valleyed
valses94514612valse_s
valuers10328942valuers
values94314942value_s
valves124113782valve_s
varlets10411572varlets
volley12419742volley_
wallets103914832wallets
walleye1336242walleye
walleyes1435602walleyes
abbeys13538423_abbeys
ables75935543_able_s
aglets73915683_aglets
agley96917333_agley_
alders74218423_alders
alecs76620733_a_lecs
alefs87319663_a_lefs
ales47067103_a_le_s
aliens65619213_aliens
allay85620393_allay_
allee54932123_alle_e
allege74314653_allege
alleges84212573_alleges
allele64514563_allele
alleles73812033_alleles
allies63827673_allies
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloy85519973_alloy_
alls46740923_all__s
ally76935643_all_y_
allyl85310543_all_yl
allyls9437273_allyls
almehs11619493_almehs
almes75126543_alme_s
aloes54933673_aloe_s
alters64924223_alters
always12409133_always
arles56735743_arle_s
awless939263_awless
axles125219473_axle_s
bailees93914383bailees
bailers94221353bailers
bailey115015673bailey_
baleens938473baleens
balers85626933ba_lers
bales76250083ba_le_s
balkers134915723balkers
ballads104212913ballads
balled94926893balle_d
baller83825203balle_r
ballet84733973balle_t
ballies93725743ballies
ballons93916963ballons
ballots94116033ballots
balls76236413ball__s
ballsy11508873ballsy_
bally105530103ball_y_
baloneys1334663baloneys
barless94317003barless
barley115116763barley_
barneys12569563barneys
bawlers124412733bawlers
belles85325993belle_s
billers94720833billers
billets94516153billets
blueys11419523_blueys
bullets93516393bullets
burleys12479673burleys
cablers114416713cablers
cables104527553cable_s
cablets114216343cablets
calces104420053calce_s
calkers134414693calkers
callans94518473callans
callas84526753call_as
callboys1585183callboys
called94126733calle_d
callee84327293calle_e
caller85125483calle_r
callet84536763calle_t
callous93516603callous
calls75634733call__s
callus85317073call_us
calves115119283calve_s
calxes154113033calxe_s
camlets114314623camlets
capless114312763capless
caplets114914523caplets
carles85435083carle_s
carless95118493carless
carneys124310543carneys
caules85927253caule_s
causeys12387223causeys
charleys1695633charleys
coalless1038193coalless
collets93517903collets
cullays12347703cullays
cullers93418853cullers
cullets94015613cullets
dales66439743da_le_s
dalliers93610613dalliers
dallies84023193dallies
dally95324743dall_y_
darkeys15356533darkeys
diallers957773diallers
doyleys14384923doyleys
eagles73819163eagle_s
eaglets84111663eaglets
earless74316073earless
fablers124812613fablers
fables114921673fable_s
failles102914133faille_s
falces115216003falce_s
fallals103310193fallals
fallen93813373falle_n
faller94621233falle_r
fallows133713973fallows
falls85727653fall__s
falters103916473falters
farles96025783farle_s
fatless103212203fatless
fellers104117543fellers
fillers104320213fillers
filles94224523fille_s
fillets103414753fillets
fleys117015603__fleys
foleys123810463_foleys
folles93820473folle_s
fullers103817373fullers
gables94222333gable_s
galeas74618513ga_leas
gales65442483ga_le_s
galilees936333galilees
galleass935053galleass
galled84622863galle_d
gallein8299043gallein
galleins9258693galleins
galleon8278713galleon
galleons9258443galleons
gallery11468743gallery
gallet73630853galle_t
galleta8399643galleta
galletas9308133galletas
gallies84122713gallies
gallons83015953gallons
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galls64729323gall__s
gallus74313203gall_us
gally95026173gall_y_
gaolers83511563gaolers
gapless10349993gapless
garveys14124463garveys
gasless8319013gasless
gillers84216903gillers
gleys96514853__gleys
goalless935723goalless
gullets84013713gullets
gulley104213163gulley_
hailers104017263hailers
halers94926913ha_lers
hales85449843ha_le_s
hallahs133912463hallahs
hallel93514093halle_l
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hall_os
hallows134417393hallows
halls85633783hall__s
hallways1745423hallways
haloes94623863haloe_s
halters104619803halters
haltless11308443haltless
halvers133311423halvers
halves124717093halve_s
hamlets123211403hamlets
haoles94919803haole_s
hapless123311333hapless
haslets102510863haslets
hatless103813443hatless
haulers104012443haulers
hawkeys20414703hawkeys
hellers103619833hellers
henleys1334843henleys
hillers103718733hillers
hollers103818233hollers
hullers103616263hullers
hurleys13407333hurleys
jagless1537103jagless
jailers144114043jailers
jarveys20123413jarveys
jawless1745653jawless
kales95730983ka_le_s
kayles134712003kayle_s
killers114215583killers
lackeys16458263lackeys
ladlers84613573ladlers
ladles74619543ladle_s
lallans74113533lallans
lalled74218753lalle_d
lalls55324133lall__s
langleys1245103langleys
lawless1037033lawless
leys76430183___leys
lollers72713793lollers
lullers73213353lullers
macles107023223macle_s
maglevs1334693maglevs
magueys1333943magueys
mailers94420333mailers
mailes84329113maile_s
mailless10248583mailless
males75049793ma_le_s
malled94626113malle_d
mallee84525593malle_e
mallei84414633malle_i
mallet84433053malle_t
mallows123714323mallows
malls76233433mall__s
malmseys1541903malmseys
malteds10377603malteds
mameys13449523ma_meys
mammeys13376723mammeys
manless93012933manless
maples104819423maple_s
mateys115610943ma_teys
matless93014043matless
maulers94213303maulers
mealless10288363mealless
medleys13115333medleys
millers93621343millers
milles84526563mille_s
millets94216843millets
mooleys1236863mooleys
motleys1235683motleys
muleys11409643_muleys
mullens93611313mullens
mullers93217303mullers
mullets93614783mullets
mulley114013453mulley_
nailers73215893nailers
naleds7469133na_leds
napless93110283napless
oarless73913373oarless
ovally12278443ovall_y_
ovalness1134673ovalness
padles95221123padle_s
paisleys1333343paisleys
palely11311933palely_
pales75753803pa_le_s
palets85122313pa_lets
palfreys1642003palfreys
palled94625163palle_d
pallet84232653palle_t
pallors9314363pallors
palls74332563pall__s
pally105727123pall_y_
palmers113513623palmers
palters94021683palters
parlays123910453parlays
parles86334403parle_s
parley116718363parley_
parsleys1335083parsleys
pellets94014783pellets
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
pullers93618483pullers
pullets94015163pullets
pulley113713403pulley_
pusleys12286233pusleys
railers74420663railers
rales54947493ra_le_s
ralliers84010833ralliers
rallies73823343rallies
rally84725903rall_y_
rallye95110163rall_ye
rayless10239003rayless
ridleys11145783ridleys
rilles64725503rille_s
rillets74216153rillets
rollers73117473rollers
sables85026693sable_s
sailers73822323sailers
sailless82410373sailless
saleps85014903sa_leps
sales56055593sa_le_s
sallet63734543salle_t
salliers83613343salliers
sallies73227813sallies
sallows103915553sallows
sally85129713sall_y_
salters73622253salters
saltless8259343saltless
salvers103916003salvers
salves94221763salve_s
samlets93813553samlets
sapless93313443sapless
sawneys13274643sawneys
sellers73721313sellers
selles64426983selle_s
sillers73822103sillers
slaveys13415203slaveys
smileys12336323smileys
spallers102910733spallers
tables84524893table_s
tablets94714383tablets
tailers73720183tailers
tailles72516473taille_s
tailless8239083tailless
talers64628143ta_lers
tales55451373ta_le_s
talkers113513213talkers
tallboys1374623tallboys
taller63721963talle_r
tallest7317093tallest
talliers83711373talliers
tallies73624603tallies
tallis63319963tall_is
tallits73215993tallits
tallness837103tallness
tallols73311363tallols
tallows103313743tallows
talls55133433tall__s
tally84526863tall_y_
tawneys13324773tawneys
taxless1436913taxless
tellers73717593tellers
tellys9348843tell_ys
tillers73418743tillers
tollers73217463tollers
tomalleys1441673tomalleys
trawleys14284383trawleys
trolleys11315693trolleys
tulles63218893tulle_s
vailed104619293vaile_d
vails85825933vail__s
vakeels14113733vakeels
vale74937343va_le__
valet84337873va_le_t
valgus1047103va_lgus
valines104520213valines
valises103516263valises
valkyr1632403va_lkyr
valkyrs1732163valkyrs
vallate103016563vallate
valors93413773va_lors
valours10248743valours
valse85117523valse__
value85719093value__
valued104011153value_d
valueless1242843valueless
valuer93911443value_r
valutas1036533valutas
valve114515933valve__
valved136711043valve_d
valveless1543163valveless
valvelets1542793valvelets
valvules1443473valvule_s
vampers143111623vampers
vanes85130973va_ne_s
vanners103612843vanners
variers103712663variers
varies94330873varie_s
varlet9423503varle_t
varves124414783varve_s
vases84626263va_se_s
vaulters11206173vaulters
vaults94511673vaul_ts
vaulty12388443vaulty_
vealers103214293vealers
veilers103911823veilers
vellums1235293vellums
velvets13326693velvets
vialled1156843vialle_d
vilely1239443vilely_
villas96117263vill_as
villein1036753villein
villeins1136043villeins
villous102810023villous
vills86429323vill__s
villus93611223vill_us
violets102210003violets
voiles94616443voile_s
voles86234043v_ole_s
volleyed1543533volleyed
volleyer1443163volleyer
volleyers1542773volleyers
voltes94915583volte_s
vowless13246603vowless
wailers103916803wailers
walers94824463wa_lers
wales86142833wa_le_s
walies95324523walie_s
walkers143411473walkers
wallahs13409473wallahs
wallas95719393wall_as
walled104021293walle_d
wallet93327093walle_t
walleyed1534153walleyed
wallies103320743wallies
wallops123410413wallops
wallows133613533wallows
walls85529383wall__s
wally114625093wall_y_
warless104015103warless
waveys15597013wa_veys
waylays1634673waylays
wayless13308243wayless
willers103517913willers
willets104414323willets
yellers103912953yellers

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.390458182.1
2DLD Change Limit1340274496.06322105.7
3Display Results4494490.1732595.4
 (SQL Overall)1786914496.62626968.2
 
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.