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 “swanks” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
swanks13481156(None) 
shanks135315581shanks
skanks94710831skanks
spanks124514121spanks
stanks104917701stanks
swank125318231swank_
swanky16447971swanky
swans84625011swan_s
swinks134610651swinks
wanks126124481_wanks
banks115527902_banks
blanks124112892blanks
branks124817382branks
bwanas1157442bwanas
clanks124615182clanks
cranks125015312cranks
flanks133913402flanks
franks134912732franks
hanks126226862_hanks
planks124116752planks
pranks124814722pranks
ranks95225732_ranks
sacks114228872s_acks
sands65228582s_ands
sanes55649072s_anes
sank85236822s_ank_
sans45153352s_an_s
sarks96632462s_arks
scans74625102scan_s
scants85219722scants
sewans95215902sewan_s
shacks154817562shacks
shank125422192shank_
sharks135019722sharks
sinks95529182s_inks
skank84415582skank_
skanky12476962skanky
skinks94511652skinks
skunks9468162skunks
slacks124416532slacks
slangs75615342slangs
slank95822772slank_
slants64819082slants
slinks104315152slinks
smacks144112322smacks
snacks124514552snacks
snarks104815732snarks
soaks95220292soa_ks
sowans94215892sowan_s
spank115919572spank_
spans74528732span_s
sparks124616362sparks
spunks12349332spunks
stacks124317262stacks
stalks104614552stalks
stands75118052stands
stanes64933402stanes
stangs75018162stangs
stank95823302stank_
stinks105616832stinks
swabs105817272swa_bs
swages104417072swages
swags94921252swa_gs
swails94913122swails
swains94513952swains
swales93920762swales
swamis114212292swamis
swamps135910262swamps
swan76631312swan__
swang95519722swan_g
swanked15359542swanked
swanker14369482swanker
swankest15105932swankest
swanny12336822swanny
swaps104819202swa_ps
swards105415132swards
swarfs125612062swarfs
swarms116112162swarms
swaths125312642swaths
swats85726862swa_ts
sways115518462swa_ys
swings104714452swings
swink125116352swink_
tanks94624732_tanks
thanks134313132thanks
tranks104017762tranks
twangs10358092twangs
twanky16445772twanky
wacks146626282_wacks
walks126218502_walks
wands96425482_wands
wanes85040882_wanes
wank115632502_wank_
wans76452262_wan_s
wants87932212_wants
warks127932402_warks
wauks125515162_wauks
winks125325432_winks
wonks124818342_wonks
yanks125316572_yanks

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 Filter178691825510.1261418182.5
2DLD Change Limit825511002.18637763.5
3Display Results1001000.0333030.3
 (SQL Overall)1786911002.34576200.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.