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

91 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
stinker11331331(None) 
sinker103620901s_inker
skinker10319441skinker
sticker133515881sticker
stinger84314681stinger
stinkers123111131stinkers
stinkier12278541stinkier
stinter73614511stinter
tinker103619921_tinker
blinker134110212blinker
clinker133811662clinker
drinker12349482drinker
inker94421092__inker
jinker174013542_jinker
linker104321472_linker
pinker125322442_pinker
plinker134010962plinker
prinker133412742prinker
seiner64622482sein_er
shicker163914822shicker
shikker13277022shikker
shiner93820872shin_er
shinier104113142shinier
shirker143711342shirker
shrinker15236362shrinker
sicker124023902s_icker
siker95326032s_i_ker
singer74227312s_inger
sinkers113618542s_inkers
sinner64320602s_inner
sinter63625922s_inter
skanker10268482skanker
skinked11339012skinked
skinkers11298182skinkers
skinner11348092skinner
slicker133314532slicker
slinger83413832slinger
slinked123011382slinked
slinkier12206932slinkier
smirker13327422smirker
snicker133012672snicker
spanker133612352spanker
spiker124315662spi_ker
spinier93715162spinier
spinner93912262spinner
stacker134416262stacker
stainer73614922stain_er
stalker113912252stalker
stander84316162stander
starker114114692starker
sticked144114632sticked
stickers142913032stickers
stickier14229762stickier
stickler14259572stickler
stiffer13319392stiffer
stifler102911472stifler
stiller73414292stiller
stingers94012742stingers
stingier9279122stingier
stink95122502stink__
stinkard1344322stinkard
stinkeroo1342342stinkeroo
stinko10499392stink_o
stinks105616832stink_s
stinky134611072stink_y
stinted82914192stinted
stinters83312752stinters
stirrer7338232stirrer
stiver93915732sti_ver
stocker133713082stocker
stoker104417622st_oker
stoner65823202ston_er
stonier72013792stonier
stooker113811732stooker
striker113714172striker
stringer93812942stringer
stroker114113522stroker
stunner7349192stunner
swanker14369482swanker
swinger113812562swinger
swinked15349032swinked
tanker104521122_tanker
thinker143610682thinker
ticker124321502_ticker
tinder73821802_tinder
tinier63622232_tinier
tinkers113517142_tinkers
tinkler113610542_tinkler
tinner64119962_tinner
tinter63923642_tinter
winker134220292_winker

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 Filter1786911076710.1231452772.4
2DLD Change Limit107671912.89337217.8
3Display Results91910.0303033.3
 (SQL Overall)178691913.04658664.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.