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

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
swank12531823(None) 
sank85236831s_ank
shank125422191shank
skank84415581skank
slank95822771slank
spank115919571spank
stank95823301stank
swan76631311swan_
swang95519721swang
swanks134811561swanks
swanky16447971swanky
swans84625011swans
swink125116351swink
wank115632511_wank
bank105835752_bank
blank115418552blank
brank115222282brank
bwana10310242bwana
clank114719522clank
crank114819612crank
dank95828242_dank
drank104816202drank
flank124618092flank
frank124417512frank
hank115134142_hank
hwan105716892hwan_
lank84734452_lank
plank115221142plank
prank115019452prank
rank85135532_rank
sack105337312s_ack
sand55338472s_and
sane45954342s_ane
sang55441242s_ang
sans45153362s_ans
sark84938972s_ark
sawn75428162sawn_
scan65530452scan_
scans74625102scans
scant79735072scant
sewan85921292sewan_
sewans95215902sewans
shack145321752shack
shanks135315582shanks
shark126225022shark
shrank13359122shrank
sink86640142s_ink
skanks94710832skanks
skanky12476962skanky
skink85916852skink
skunk85011762skunk
slack115021762slack
slang66324022slang
slant55238702slant
slink95422912slink
slunk95016302slunk
smack134615452smack
snack114718062snack
snark95419942snark
soak87227662soa_k
sowans94215892sowans
span65234662span_
spang84919732spang
spanks124514122spanks
spans74528732spans
spark114920892spark
spunk114513402spunk
stack114421692stack
stalk94518002stalk
stand65923282stand
stane55933002stane
stang66424692stang
stanks104917702stanks
stark95425622stark
stink95122502stink
stunk94616292stunk
sunk85031812s_unk
swab96825312swa_b
swabs105817272swabs
swag87526732swa_g
swage94919562swage
swags94921252swags
swail86217162swail
swain84919052swain
swains94513952swains
swale85221592swale
swam96329982swa_m
swami105614522swami
swamp125015322swamp
swamy136714402swamy
swanked15359542swanked
swanker14369482swanker
swanny12336822swanny
swap95925432swa_p
swaps104819202swaps
sward94221462sward
sware85828212sware
swarf115324652swarf
swarm106218842swarm
swart86234642swart
swash116316752swash
swat77244442swa_t
swath115920382swath
swats85726862swats
sway107128232swa_y
sways115518462sways
swine85625302swine
swing96124842swing
swinks134610652swinks
swung95610562swung
tank85134032_tank
thank125817802thank
trank96222422trank
twang94511862twang
twanky16445772twanky
wack135330912_wack
walk115625612_walk
wan66761942_wan_
wand85833882_wand
wane76344722_wane
wanks126124482_wanks
wans76452272_wans
want76156172_want
wany106432362_wany
wark115737772_wark
wauk115220592_wauk
wink116435022_wink
wonk116125302_wonk
yank115423672_yank

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.300595636.7
2DLD Change Limit538001291.64032804.9
3Display Results1291290.0304300.0
 (SQL Overall)1786911291.97090706.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.