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

116 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
sonly8571805(None) 
only75319721_only
sonny85016101sonny
sonsy86416371sonsy
boney105227312boney
bonny105816622bonny
bony96732082bon_y
coaly105521592coaly
colly104926772colly
coly96940532co_ly
coney105932882coney
conky145818742conky
cony96537832con_y
cooly105525422cooly
coyly135614892coyly
doily95321032doily
dolly96125202dolly
donsy96414682donsy
dooly94821802dooly
doyly124514012doyly
folly115022602folly
fondly13299042fondly
godly104913292godly
golly95121102golly
holly114824432holly
holy106333432ho_ly
honey115629912honey
honky156218522honky
hooly115022222hooly
hotly115815482hotly
inly75622212_inly
jolly154517512jolly
jowly186410902jowly
lolly85120662lolly
lonely92912472lonely
longly10279602longly
lowly114113332lowly
manly105022952manly
molly105222492molly
moly96031912mo_ly
money104826842money
mony96830012mon_y
nobly105314402nobly
noily86120992noily
nonyl849772nonyl
oily77932252_oily
onlay84212942_onlay
poly96235152po_ly
pony96434052pon_y
roily86121112roily
sadly94519122sadly
sally85129712sally
sandy94221132sandy
sanely93114612sanely
scaly104718722scaly
seely84522632seely
shaly114322862shaly
shily115222012shily
shoaly124010772shoaly
shyly144811572shyly
silly84527622silly
singly104015852singly
slily85820032slily
slowly1237152slowly
sly66228562s__ly
slyly11489532slyly
snowy115011562snowy
soapy106114782soapy
socle7419572socle
soddy104210702soddy
softly12457762softly
softy115414482softy
soggy105413902soggy
soil46138832soil_
soils55327982soils
sol37256622so_l_
sola45541862so_la
sold54837412so_ld
sole46053672so_le
solely93714212solely
soli46637012so_li
solo45538942so_lo
sols45448162so_ls
son37761952son__
sonar56523422sonar
sonde64622832sonde
sone46649982son_e
sones55444142sones
song55133672son_g
songs67725552songs
sonic75225292sonic
sons46049552son_s
sooey84522432sooey
sooty84924842sooty
sophy136611762sophy
soppy125113522soppy
sorely94618012sorely
sorry84618252sorry
soul46435712soul_
souls55127362souls
soundly1136682soundly
soupy106115402soupy
sourly93612212sourly
soy67851452so__y
spongy1236742spongy
stoney96217352stoney
stonily1049432stonily
stony85818642ston_y
sully84622902sully
sunny84917742sunny
surly85124432surly
toney86027412toney
tony75635152ton_y
wanly115118022wanly
wonky154011772wonky
wooly114417672wooly

Search took 2 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 Limit538001161.43637465.2
3Display Results1161160.0303866.7
 (SQL Overall)1786911161.779100444.6
 
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.