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

98 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
thank12581780(None) 
hank115134131_hank
shank125422191shank
tank85134011t_ank
thack144915171thack
than76128771than_
thane86122531thane
thanks134313131thanks
think125018791think
thunk124911851thunk
trank96222421trank
bank105835742_bank
bethank1666272bethank
bhang115512922bhang
blank115418552blank
brank115222282brank
chalk144814602chalk
chang115418562chang
chant105932692chant
chark144222712chark
chink145321592chink
chunk144812382chunk
clank114719522clank
crank114819612crank
dank95828232_dank
dhak125512032dha_k
drank104816202drank
ethane94613242ethane
flank124618092flank
frank124417512frank
hack135134542_hack
haik115526982_haik
hand86833702_hand
hang85535542_hang
hanks126226862_hanks
hanky155418292_hanky
hant75461582_hant
hark115237392_hark
hawk145521152_hawk
honk116931192_honk
hunk116029542_hunk
khan115819142khan_
khans124615172khans
lank84734442_lank
plank115221142plank
prank115019452prank
rank85135522_rank
sank85236822_sank
shack145321752shack
shanks135315582shanks
shark126225022shark
shrank13359122shrank
skank84415582skank
slank95822772slank
spank115919572spank
stank95823302stank
swank125318232swank
tack106536292t_ack
talk86230092t_alk
tan37167562t_an_
tang56138662t_ang
tanka93817482t_anka
tanks94624732t_anks
tans46154812t_ans
task85326652t_ask
teak85930842tea_k
thacks154311922thacks
thae76825562tha_e
thanes94918982thanes
thanked15469152thanked
thanker14309592thanker
tharm105916642tharm
that75639322tha_t
thaw107521312tha_w
thaws116515462thaws
then78429692then_
thens85921832thens
thick145613352thick
thin76732382thin_
thine85026852thine
thing96622962thing
thinks134613352thinks
thins85826322thins
thong95014172thong
thunks13459032thunks
thwack1834212thwack
track114823012track
traik95418202traik
tranks104017762tranks
tranq145416892tranq
trans54933042trans
trunk94713042trunk
twang94511852twang
twanky16445772twanky
wank115632502_wank
whack174813022whack
whang124813382whang
yank115423662_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.0802233637.5
2DLD Change Limit53800982.21624278.0
3Display Results98980.0801225.0
 (SQL Overall)178691982.37675206.6
 
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.