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

119 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
think12501880(None) 
chink145321591chink
thank125817801thank
thick145613351thick
thin76732391thin_
thine85026861thine
thing96622981thing
thinks134613361thinks
thins85826331thins
thunk124911851thunk
ahing98928352ahing
bethink1677202bethink
blink115720142blink
boink115516332boink
brink116122002brink
chick165419132chick
chin96934742chin_
china105022482china
chine105231722chine
chinks155817572chinks
chinky185610542chinky
chino105823312chino
chins105631462chins
chirk144516182chirk
chunk144812382chunk
clink115320042clink
dink97137812_dink
drink106816382drink
fink117532132_fink
gink97129532_gink
hank115134142_hank
hick135530312_hick
hin67559572_hin_
hind85529762_hind
hinky155618752_hinky
hins76448002_hins
hint77455752_hint
honk116931192_honk
hunk116029542_hunk
ink76433642__ink
jink156227212_jink
kink76034412_kink
link86943452_link
mink106636542_mink
ohing96018812ohing
oink85429352_oink
pink107039392_pink
plink115219122plink
prink114719672prink
reink95518092reink
rethink1488882rethink
rhino84614322rhino
rink87737002_rink
shank125422192shank
shin75634312shin_
shine85533092shine
shins85131042shins
shiny115122142shiny
shirk124817842shirk
shrink134511732shrink
sink86640152_sink
skink85916862skink
slink95422912slink
stink95122502stink
swink125116352swink
tahini939892tahini
tain45548072tain_
tains54936322tains
taint55542282taint
tank85134032t_ank
teind6213612teind
thack144915172thack
than76128772than_
thane86122532thane
thanks134313132thanks
thein85919022thein_
theine94814922theine
theins95015422theins
then78429692then_
thens85921832thens
thicks154511992thicks
thief114516302thief
thigh12410122thigh
thill85918732thill
things104914302things
thinker143610682thinker
thinly1238672thinly
thio77225412thi_o
thiol87616042thiol
thir76420542thi_r
third95912492third
thirl85416822thirl
this76027382thi_s
thong95014182thong
thunks13459032thunks
tick106231232t_ick
tin36362182t_in_
tine45855142t_ine
ting56139922t_ing
tins45251312t_ins
tint46758872t_int
tiny76134642t_iny
trank96222422trank
trick115420692trick
trine54734602trine
trunk94713042trunk
twin76023082twin_
twine85822362twine
twins85118982twins
twiny116012812twiny
tyin76424002tyin_
tying96019842tying
unthink1457002unthink
whin105225692whin_
whine116022812whine
whins114922332whins
whiny144915572whiny
whisk154510142whisk
wink116435032_wink

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.296603685.8
2DLD Change Limit538001191.40638264.6
3Display Results1191190.0303966.7
 (SQL Overall)1786911191.732103170.3
 
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.