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
dink97137802_dink
drink106816382drink
fink117532122_fink
gink97129522_gink
hank115134142_hank
hick135530302_hick
hin67559562_hin_
hind85529752_hind
hinky155618752_hinky
hins76447992_hins
hint77455742_hint
honk116931192_honk
hunk116029542_hunk
ink76433632__ink
jink156227202_jink
kink76034402_kink
link86943442_link
mink106636532_mink
ohing96018812ohing
oink85429342_oink
pink107039382_pink
plink115219122plink
prink114719672prink
reink95518092reink
rethink1488882rethink
rhino84614322rhino
rink87736992_rink
shank125422192shank
shin75634312shin_
shine85533092shine
shins85131042shins
shiny115122142shiny
shirk124817842shirk
shrink134511732shrink
sink86640142_sink
skink85916852skink
slink95422912slink
stink95122502stink
swink125116352swink
tahini939892tahini
tain45548072tain_
tains54936322tains
taint55542282taint
tank85134022t_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
tick106231222t_ick
tin36362172t_in_
tine45855132t_ine
ting56139902t_ing
tins45251302t_ins
tint46758862t_int
tiny76134632t_iny
trank96222422trank
trick115420692trick
trine54734602trine
trunk94713042trunk
twin76023082twin_
twine85822362twine
twins85118982twins
twiny116012812twiny
tyin76424002tyin_
tying96019842tying
unthink1457002unthink
whin105225692whin_
whine116022812whine
whins114922332whins
whiny144915572whiny
whisk154510142whisk
wink116435022_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.313570897.8
2DLD Change Limit538001191.47036598.6
3Display Results1191190.0303966.7
 (SQL Overall)1786911191.81398560.9
 
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.