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

139 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
stony8581864(None) 
astony9510521astony
atony87218851atony
stogy95414081stogy
stone55431181stone
stoney96217351stoney
story86723031story
tony75635151_tony
agony96415652agony
atomy107415192atomy
atone56527982atone
atopy106813392atopy
betony114211582betony
bony96732082_bony
cony96537832_cony
crony105918672crony
ebony104511512ebony
goony95519782goony
irony85015902irony
loony86918962loony
mony96830012_mony
moony104818272moony
ostomy1137832ostomy
peony105717562peony
phony136715442phony
pony96434052_pony
satiny93817982satiny
saxony1636232saxony
scone74621832scone
seton55223542seton_
setons64620172setons
shiny115122142shiny
shone83725982shone
showy145714012showy
simony1137902simony
smoky14388682smoky
snowy115011562snowy
son37761952s_on_
sone46649982s_one
song55133672s_ong
sonly85718052s_only
sonny85016102sonny
sons46049552s_ons
sonsy86416372s_onsy
sooey84522432sooey
soon46240502soon_
sooty84924842sooty
soy67851452s_o_y
spiny104921302spiny
spongy1236742spongy
spoony114111792spoony
stagy96618892stagy
stand65923282stand
stane55933002stane
stang66424682stang
stank95823302stank
stay78333722st_ay
steno54716862steno
stent55634512stent
stewy116112062stewy
stey76224412st_ey
stimy105114742stimy
sting65330242sting
stingy105213202stingy
stink95122502stink
stinky134611072stinky
stint57037662stint
stoa45425912sto_a
stoae55024262stoae
stoai55417872stoai
stoas55126022stoas
stoat57135952stoat
stob66724612sto_b
stobs75718232stobs
stock114417562stock
stocky15369152stocky
stodgy11415732stodgy
stogey105811542stogey
stoic7317252stoic
stoke94922512stoke
stole54928812stole
stoma75918272stoma
stomp95616662stomp
stoned75923142stoned
stoner65823202stoner
stones65130032stones
stonily1049432stonily
stood65517712stood
stook95218212stook
stool55619892stool
stoop75821542stoop
stop66532032sto_p
stope74727242stope
stops74827282stops
stopt76528352stopt
store56333812store
storey95217612storey
stork96819692stork
storm76520402storm
stormy115510732stormy
stoss54316342stoss
stot46347332sto_t
stots54828552stots
stott56929792stott
stound7399902stound
stoup75517072stoup
stour54916742stour
stoury9529942stoury
stout57434052stout
stove85220252stove
stow77325742sto_w
stowp105614232stowp
stows86622702stows
stray88525572stray
strong74914882strong
stroy87720392stroy
study94411792study
stun45623452stun_
stung65417152stung
stunk94616292stunk
stuns54719492stuns
stunt55328172stunt
sty66227312st__y
stymy13358292stymy
sunny84917742sunny
swoony12408262swoony
syntony1344522syntony
tiny76134632_tiny
toby96322292_toby
tody86327212_tody
ton310265102_ton_
tone46953742_tone
toney86027412_toney
tong56434352_tong
tons46553052_tons
tory75840542_tory
towny116114492_towny
towy105325472_towy
toy69655192_to_y

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.310576422.6
2DLD Change Limit538001391.61033416.1
3Display Results1391390.0463021.7
 (SQL Overall)1786911391.96690890.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.