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

113 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
sadly9451912(None) 
badly114918761badly
madly115218131madly
sally85129711sally
ably99725132_ably
agly86821802_agly
ally76935642_ally
baddy125016022baddy
baldly12479832baldly
baldy115518932baldy
bally105530102bally
caddy125414022caddy
cadgy125210782cadgy
daddy116212562daddy
daily95922332daily
dally95324742dally
deadly113811472deadly
early85324122early
faddy135511622faddy
fatly115716802fatly
gadfly1434662gadfly
gaily95020972gaily
gally95026172gally
gayly124513092gayly
gladly11497932gladly
godly104913292godly
haply135915062haply
hardly135112832hardly
idly85617322_idly
ladle66320442ladle
lady86527152lad_y
laxly15610102laxly
manly105022952manly
marly106925612marly
oddly1037162oddly
paddy125913592paddy
padle84522342padle
pally105727122pally
paly95835532pa_ly
patly105020582patly
rally84725902rally
rawly115115832rawly
redly94217202redly
sable74732162sable
sad47459202sad__
saddle83915492saddle
sade55544472sad_e
sades65239892sades
sadhe94815132sadhe
sadhu9459962sadhu
sadi55834642sad_i
sadis64930852sadis
safely12249392safely
sagely102811382sagely
saggy105917462saggy
sagy85327082sa_gy
sail45447162sail_
sails55738102sails
sal36462882sa_l_
sale44959702sa_le
sall44544682sa_ll
salp64534092sa_lp
sals46851672sa_ls
salt45758522sa_lt
salty85524382salty
sandfly1435642sandfly
sandy94221132sandy
sanely93114612sanely
sappy125413472sappy
sarky125521782sarky
sassy85813812sassy
satay84718462satay
saucy104615162saucy
saul45836522saul_
sauls55128122sauls
sault55834962sault
saury84317222saury
savoy114713882savoy
savvy14497502savvy
sawfly1535132sawfly
say67264762sa__y
scaly104718722scaly
sedgy104512792sedgy
seely84522632seely
shadfly1733782shadfly
shadily1437722shadily
shady125416512shad_y
shaly114322862shaly
shily115222012shily
shyly144811572shyly
sidle65124032sidle
silly84527622silly
slily85820032slily
sly66228562s__ly
slyly11489532slyly
snarly93815002snarly
soddy104210702soddy
sonly85718052sonly
stably113314122stably
staidly1136682staidly
studly10397692studly
suably112814532suably
sudsy95010682sudsy
sully84622902sully
surly85124432surly
tally84526862tally
usably11288982usably
waddly14478722waddly
waddy135312992waddy
wady115324992wad_y
wally114625092wally
waly105830902wa_ly
wanly115118022wanly

Search took 3 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.313570897.8
2DLD Change Limit538001131.73331044.4
3Display Results1131130.0303766.7
 (SQL Overall)1786911132.07686074.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.