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

150 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
swannery143355(None) 
cannery123610012_cannery
scanner94411812scanner_
scanners10379702scanners
shinnery14305682shinnery
spanner94312562spanner_
spanners103710772spanners
spinnery13416592spinnery
stannary1144612stannary
swanherd1533482swanherd
swanker14369482swanker_
swanned11358172swanne_d
swanny12336822swann__y
swinney13365972swinne_y
tannery10388662_tannery
wanner94019622_wanner_
banner84421503_banner_
banners94018713_banners
beanery1237563bea_nery
branner94212373branner_
branners104010923branners
canner84625983_canner_
canners93822663_canners
chancery18366653chancery
deanery1137613dea_nery
fanner94218183_fanner_
fanners103914653_fanners
gunnery11376373_gunnery
hennery1335303_hennery
lanner64920603_lanner_
lanners73618333_lanners
manner84020513_manner_
mannerly1344983_mannerly
manners93417833_manners
nunnery10355303_nunnery
orangery12305543orangery
panner84224763_panner_
panners93621273_panners
planner93511623planner_
planners10399933planners
sander74828533s_ander_
sanders84025943s_anders
sanely93114613s_a_nely
saner54334323s_a_ner_
sanger74524573s_anger_
sangers84421943s_angers
santera7311303s_antera
santero7311133s_antero
sawney12387603s_awne_y
scanned104110893scanne_d
scanter94215183scanter_
scenery1236563s_cenery
scunner9358243scunner_
scunners10357303scunners
sealery104011053sea_lery
shanny124110093shann__y
shantey134210043shante_y
shinney13368303shinne_y
shunner10358643shunner_
shunners11317743shunners
sinner64320603s_inner_
sinners74019023s_inners
skanker10268483skanker_
skankers11316483skankers
skinner11348093skinner_
skinners12347293skinners
slabbery15375773slabbery
slander84015443slander_
slanders94014013slanders
slavery13407893sla_very
sneery93610413s__neery
spanker133612353spanker_
spankers14369863spankers
spanned104111223spanne_d
spawner12347363spawner_
spawners13396493spawners
spinner93912263spinner_
spinners103810863spinners
spinney12438923spinne_y
staggery13346243staggery
stainer73614923stainer_
stainers83212173stainers
stander84316163stander_
standers93514303standers
stunner7349193stunner_
stunners8277923stunners
swabber14297963swabber_
swabbers15316743swabbers
swager104013613swa_ger_
swagers114211023swa_gers
swagger12389333swagger_
swaggers13407223swaggers
swamper14349313swamper_
swampers15317473swampers
swanherds1642543swanherds
swanked15359543swanke_d
swankest15105933swankest
swankier15225503swankier_
swankily1833833swankily
swanky16447973swa_n_ky
swanneries1344363swanneries
swanning12338813swanning
swapper14359703swapper_
swappers15358083swappers
swarmer1247803swarmer_
swarmers1346323swarmers
swasher134011513swasher_
swashers14389533swashers
swather134213603swather_
swathers144512083swathers
swatter104113323swatter_
swatters113911793swatters
swayer125210973swa_yer_
swayers13398853swa_yers
sweeney13387003sweene_y
swinger113812563swinger_
swingers123710423swingers
swinneys14264203swinneys
swooner10358673swooner_
swooners11336863swooners
tanner63722293_tanner_
tanners74018393_tanners
twanger11327443twanger_
twangers12226063twangers
vanner94215843_vanner_
vanners103612843_vanners
wafery15398693_wa_fery
waggery15276903_waggery
wander104423713_wander_
wanders114221333_wanders
waney115120323_wa_ne_y
wanier93920683_wanier_
wanker134219973_wanker_
wankers144514713_wankers
wanned104318013_wanne_d
wanness102610683_wanness
wannest103915003_wannest
wanter94423053_wanter_
wanters104420093_wanters
warner93717223_warner_
warners103315563_warners
wastery134610993_wastery
watery123914493_wa_tery
wavery154610053_wa_very
winery125014283_w_inery
winner94219933_winner_
winners104316913_winners
wintery13399753_wintery
wonner95114443_wonner_
wonners104312813_wonners

Search took 9 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.440406115.9
2DLD Change Limit1461621507.65619091.2
3Display Results1501500.0632381.0
 (SQL Overall)1786911508.15921901.1
 
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.