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 “sally” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

209 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
sally8512971(None) 
ally76935641_ally
bally105530101bally
dally95324741dally
gally95026171gally
pally105727121pally
rally84725901rally
sadly94519121sadly
sall44544681sall_
salty85524381salty
silly84527621silly
sully84622901sully
tally84526861tally
wally114625091wally
ably99725132_ably
agly86821802_agly
alky115920342_alky
all36148232_all_
allay85620392_allay
alley85721672_alley
alloy85519972_alloy
alls46740922_alls
allyl85310542_allyl
anally9513502anally
badly114918762badly
baldly12479832baldly
baldy115518932baldy
balky145418242balky
ball66043322ball_
balls76236412balls
ballsy11508872ballsy
balmy125217472balmy
basally1237962basally
belly104625492belly
billy105525362billy
bully105124812bully
call66838672call_
calla74827072calla
calls75634732calls
calmly1337612calmly
chally144314292chally
colly104926772colly
cully105520462cully
daily95922332daily
delly96023872delly
dilly94923782dilly
dolly96125202dolly
dually103210062dually
dully94921632dully
early85324122early
fall75535312fall_
falls85727652falls
fatly115716802fatly
felly114922802felly
filly114424902filly
folly115022602folly
fully114820862fully
gaily95020972gaily
gall56335992gall_
galley104215452galley
galls64729322galls
gayly124513092gayly
gilly94321632gilly
golly95121102golly
gully94020682gully
hall75741162hall_
hallo85127552hallo
halls85633782halls
haply135915062haply
hilly114422162hilly
holly114824432holly
illy76925332_illy
jelly154218252jelly
jolly154517512jolly
kelly124617022kelly
lall45531312lall_
lalls55324132lalls
laxly15610102laxly
leally94012612leally
lolly85120662lolly
madly115218132madly
mall64639372mall_
malls76233432malls
malmy124816342malmy
malty106721702malty
manly105022952manly
marly106925612marly
mesally12119792mesally
misally121111062misally
molly105222492molly
nasally1057442nasally
nelly84618812nelly
orally93113592orally
ovally12278442ovally
palely11311932palely
pall65039342pall_
palls74332562palls
palmy126016732palmy
palsy105417462palsy
paly95835532pa_ly
patly105020582patly
rallye95110162rallye
rawly115115832rawly
really93315612really
sable74732162sable
safely12249392safely
sagely102811382sagely
saggy105917462saggy
sagy85327082sa_gy
sail45447162sail_
sails55738102sails
sal36462882sa_l_
salably121610742salably
salad65321832salad
salal55425702salal
salals65120082salals
salary9515212salary
sale44959702sa_le
salep77022952salep
sales56055592sales
salic73424712salic
salify12311372salify
sallet63734542sallet
sallow94315752sallow
sallowy13369342sallowy
salmi7815862salmi
salol55222142salol
salols64017872salols
salon55228552salon
salp64534092sa_lp
salpa75018352salpa
salps74423242salps
sals46851672sa_ls
salsa56718922salsa
salt45758522sa_lt
saltily10310542saltily
salts55431882salts
salve85022132salve
salvo84415642salvo
sandy94221132sandy
sanely93114612sanely
sappy125413472sappy
sarky125521782sarky
sassy85813812sassy
satay84718462satay
saucy104615162saucy
saul45836522saul_
sauls55128122sauls
sault55834962sault
saury84317222saury
savoy114713882savoy
savvy14497502savvy
sawfly1535132sawfly
say67264762sa__y
scall74420372scall_
scalls84218202scalls
scaly104718722scaly
seely84522632seely
sell45840612sell_
selle54428312selle
sells55134432sells
shaley123714992shaley
shall85024052shall_
shaly114322862shaly
shelly124414472shelly
shily115222012shily
shyly144811572shyly
silky125315822silky
sill45545152sill_
sills55135992sills
silty84721632silty
slaty86523152slaty
slay76436382s_lay
slily85820032slily
sly66228562s__ly
slyly11489532slyly
small74016262small_
smalls84514122smalls
smelly114110362smelly
snarly93815002snarly
solely93714212solely
sonly85718052sonly
spall74919302spall_
spalls84217342spalls
splay105816042splay
squally1937672squally
stably113314122stably
stalely1039212stalely
stalky13499302stalky
stall54722352stall_
stalls64019932stalls
stilly93714092stilly
suably112814532suably
sulky124715362sulky
surly85124432surly
talky126215682talky
tall47240212tall_
talls55133432talls
telly84920822telly
usably11288982usably
usually1066062usually
valley124311602valley
wall76236102wall_
walla85321032walla
walls85529382walls
waly105830902wa_ly
wanly115118022wanly
welly114620012welly
willy115321912willy

Search took 4 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 Filter178691538000.310576422.6
2DLD Change Limit538002093.22016708.1
3Display Results2092090.1101900.0
 (SQL Overall)1786912093.64049090.9
 
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.