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

167 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
shank12542219(None) 
hank115134141_hank
sank85236831s_ank
shack145321751shack
shanks135315581shanks
shark126225021shark
shrank13359121shrank
skank84415581skank
slank95822771slank
spank115919571spank
stank95823301stank
swank125318231swank
thank125817801thank
bank105835752_bank
bhang115512922bhang
blank115418552blank
brank115222282brank
chalk144814602chalk
chang115418562chang
chant105932692chant
chark144222712chark
chink145321592chink
chunk144812382chunk
clank114719522clank
crank114819612crank
dank95828242_dank
dhak125512032dha_k
drank104816202drank
flank124618092flank
frank124417512frank
hack135134542_hack
haik115526982_haik
hand86833712_hand
hang85535552_hang
hanks126226862_hanks
hanky155418292_hanky
hant75461592_hant
hark115237392_hark
hawk145521152_hawk
honk116931192_honk
hunk116029542_hunk
khan115819142khan_
khans124615172khans
lank84734452_lank
plank115221142plank
prank115019452prank
rank85135532_rank
sack105337312s_ack
sand55338472s_and
sane45954342s_ane
sang55441232s_ang
sans45153362s_ans
sark84938972s_ark
scan65530452scan_
scans74625102scans
scant79735072scant
sha69837782sha__
shacko153810112shacko
shacks154817562shacks
shad86230912sha_d
shade95125582shade
shads95124482shads
shady125416512shady
shaft115725272shaft
shag86430562sha_g
shags95123862shags
shah105627782sha_h
shahs115919512shahs
shake124726402shake
shako125516092shako
shaky154616842shaky
shale85332832shale
shall85024052shall
shalt85534492shalt
shaly114322862shaly
sham96436362sha_m
shame105726702shame
shams105829412shams
shandy134710032shandy
shanked153212122shanked
shanny124110092shanny
shanti94014092shanti
shanty124715122shanty
shape105125112shape
shard96125962shard
share86437082share
sharks135019722sharks
sharn84823702sharn
sharns95516982sharns
sharny124711832sharny
sharp104922532sharp
shat76456602sha_t
shaul85418102shaul
shave114425892shave
shaw108132552sha_w
shawl116217572shawl
shawm135316152shawm
shawn116417612shawn
shaws116226262shaws
shay107133342sha_y
shays116021432shays
sheik122514662sheik
shend94719972shend
shent85933502shent
shin75634312shin_
shine85533092shine
shins85131042shins
shiny115122142shiny
shirk124817842shirk
shock144917032shock
shone83725982shone
shook124920162shook
shrink134511732shrink
shrunk13357062shrunk
shtik123210962shtik
shuck144314532shuck
shun75122772shun_
shuns85018142shuns
shunt85226512shunt
sink86640142s_ink
skanks94710832skanks
skanky12476962skanky
skink85916852skink
skunk85011762skunk
slack115021762slack
slang66324022slang
slant55238702slant
slink95422912slink
slunk95016302slunk
smack134615452smack
snack114718062snack
snark95419942snark
soak87227662soa_k
span65234662span_
spang84919732spang
spanks124514122spanks
spans74528732spans
spark114920892spark
spunk114513402spunk
stack114421692stack
stalk94518002stalk
stand65923282stand
stane55933002stane
stang66424682stang
stanks104917702stanks
stark95425622stark
stink95122502stink
stunk94616292stunk
sunk85031812s_unk
swan76631312swan_
swang95519722swang
swanks134811562swanks
swanky16447972swanky
swans84625012swans
swink125116352swink
tank85134022_tank
thack144915172thack
than76128772than_
thane86122532thane
thanks134313132thanks
think125018802think
thunk124911852thunk
trank96222422trank
wank115632512_wank
whack174813022whack
whang124813382whang
yank115423672_yank

Search took 4 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.623286823.4
2DLD Change Limit538001673.19016865.2
3Display Results1671670.0931795.7
 (SQL Overall)1786911673.90645747.8
 
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.