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

148 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
stank9582330(None) 
sank85236831s_ank
shank125422191shank
skank84415581skank
slank95822771slank
spank115919571spank
stack114421691stack
stalk94518001stalk
stand65923281stand
stane55933001stane
stang66424691stang
stanks104917701stanks
stark95425621stark
stink95122501stink
stunk94616291stunk
swank125318231swank
tank85134031_tank
bank105835752_bank
blank115418552blank
brank115222282brank
clank114719522clank
crank114819612crank
dank95828242_dank
drank104816202drank
flank124618092flank
frank124417512frank
hank115134142_hank
lank84734452_lank
plank115221142plank
prank115019452prank
rank85135532_rank
sack105337312s_ack
sand55338472s_and
sane45954342s_ane
sang55441242s_ang
sans45153362s_ans
sark84938972s_ark
satang75711562satang
scan65530452scan_
scans74625102scans
scant79735072scant
shack145321752shack
shanks135315582shanks
shark126225022shark
shrank13359122shrank
sink86640152s_ink
skanks94710832skanks
skanky12476962skanky
skink85916862skink
skunk85011762skunk
slack115021762slack
slang66324022slang
slant55238702slant
slink95422912slink
slunk95016302slunk
smack134615452smack
snack114718062snack
snark95419942snark
soak87227662soa_k
span65234662span_
spang84919732spang
spanks124514122spanks
spans74528732spans
spark114920892spark
spunk114513402spunk
stab67329932sta_b
stabs76221382stabs
stacks124317262stacks
stade64825302stade
staff113817712staff
stag57332002sta_g
stage65330192stage
stags66226742stags
stagy96618892stagy
staid66722082staid
staig65519642staig
stain55727942stain
stains64923652stains
stair54719942stair
stake95927532stake
stale55637102stale
stalks104614552stalks
stalky13499302stalky
stall54722352stall
stamp95217362stamp
stance84316912stance
stanch113812372stanch
stands75118052stands
staned74824642staned
stanes64933402stanes
stangs75018172stangs
stanol6310722stanol
stanza1537072stanza
staph104314652staph
star48037762sta_r
stare54440262stare
stars55836572stars
start55642312start
stash84916972stash
stat47352692sta_t
state56237332state
stats55933362stats
stave85324992stave
staw78627692sta_w
stay78333722sta_y
stays86022022stays
steak95219802steak
steek95418002steek
steno54716862steno
stent55634512stent
stick115121562stick
sting65330242sting
stinko10499392stinko
stinks105616832stinks
stinky134611072stinky
stint57037662stint
stirk95717412stirk
stock114417562stock
stone55431182stone
stony85818642stony
stook95218212stook
stork96819692stork
strand74514822strand
strang75718312strang
stuck114515772stuck
stun45623452stun_
stung65417152stung
stuns54719492stuns
stunt55328172stunt
sunk85031812s_unk
swan76631312swan_
swang95519722swang
swanks134811562swanks
swanky16447972swanky
swans84625012swans
swink125116352swink
tack106536292_tack
talk86230092_talk
tan37167582_tan_
tang56138692_tang
tanka93817492_tanka
tanks94624742_tanks
tans46154832_tans
task85326652_task
thank125817802thank
trank96222422trank
wank115632512_wank
yank115423672_yank

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 Filter178691538000.330541487.9
2DLD Change Limit538001482.00026900.0
3Display Results1481480.0304933.3
 (SQL Overall)1786911482.36075716.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.