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

129 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
spooneys1331458(None) 
spooney12418241spooney_
gooneys11407072_gooneys
looneys10487012_looneys
phoneys15437142_phoneys
sooners73916642s_ooners
spinneys13335552spinneys
spoofers13307322spoofers
spoolers10349362spoolers
spooned103412442spoone_d
spoonies101911752spoonies
spoons84116022spoon__s
spoony114111792spoon_y_
swooners11336862swooners
baloneys1334663baloneys
boloneys1334503boloneys
boogeys13476873_boogeys
coneys115218423__coneys
cooeys114914483_coo_eys
cookeys16478503_cookeys
crooners103911393crooners
gooney106612313_gooney_
honeys124016083__honeys
hooeys125512313_hoo_eys
hookeys17448953_hookeys
looeys95110123_loo_eys
looney94712413_looney_
moneys115513623__moneys
mooleys1236863_mooleys
mooners94015343_mooners
mooneye12116933_mooneye
mooneyes1396113_mooneyes
peones83821043_peone_s
phones114121213_phone_s
phoney143612983_phoney_
pogeys124110353_p_ogeys
pokeys15529513_p_okeys
pones74547043_p_one_s
poolers94217423_poolers
poons75430973_poon__s
poorness1036363_poorness
pooves113914713_poove_s
sawneys13274643s_awneys
schooners1445663schooners
scones84521303s_cone_s
scoopers124210193scoopers
scooters103511033scooters
scorners10228493scorners
sheeneys14294903sheeneys
shinneys14275093shinneys
shooters112811583shooters
slowness1135013slowness
snookers12398653snookers
snoopers10319843snoopers
snoozers17296943snoozers
snoozes16289783snooze_s
solonets838233solonets
sones55444143s__one_s
sonnets74211993s_onnets
sooey84522433s_oo_ey_
sooner64220463s_oone_r
soonest7415593s_oonest
sorners73416873s_orners
spadones1137253spadone_s
spanners103710773spanners
spawners13396493spawners
sphenes123013163sphene_s
spinels94512443sp_inels
spines85132033sp_ine_s
spinets94714813sp_inets
spinners103810863spinners
spinney12438923spinney_
splines94718893spline_s
splores91910953splore_s
spodes94817433sp_ode_s
spoilers10238633spoilers
spokes124417213sp_oke_s
spondees1136483spondees
spongers1137603spongers
sponges10311043sp_onges
spongy1236743sp_ongy_
spoofed13399103spoofe_d
spoofer12368723spoofe_r
spoofery16354313spoofery
spoofs114011813spoo__fs
spoofy14498553spoo_fy_
spooked144510473spooke_d
spookery17264143spookery
spookiness1644433spookiness
spooks124312933spoo__ks
spooky15418093spoo_ky_
spooled104613523spoole_d
spooler93711383spoole_r
spools85115913spoo__ls
spoon74719443spoon___
spoonerism1452483spoonerism
spoonful1343753spoonful
spoonfuls1452863spoonfuls
spoonier10167653spoonier
spooniest11178133spooniest
spoonily1335233spoonily
spooning112811443spooning
spoored104411293spoore_d
spoors84014033spoo__rs
spores84726613sp_ore_s
sporters103714063sporters
spotless1037043spotless
spotters104313383spotters
spouses92912813spouse_s
spouters104011163spouters
spryness1334003spryness
spumones1254953spumone_s
spurners10288493spurners
spurreys13364603spurreys
stogeys11486123s_togeys
stoners74817953s_toners
stones65130033s_tone_s
stoney96217353s_toney_
stooges83611483stooge_s
stookers12449793stookers
stoopers103711303stoopers
storeys10559653s_toreys
sweeneys14294023sweeneys
swinneys14264203swinneys
swooned11368593swoone_d
swooner10358673swoone_r
swoons94511143swoon__s
swoony12408263swoon_y_
swoopers13317523swoopers

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621296.57622226.6
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.04525364.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.