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

219 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
thin7673239(None) 
chin96934741chin
hin67559561_hin
shin75634311shin
tain45548071tain
than76128771than
thein85919021thein
then78429691then
thine85026861thine
thing96622981thing
think125018801think
thins85826331thins
thio77225411thio
thir76420541thir
this76027381this
tin36362171t_in
twin76023081twin
tyin76424001tyin
whin105225691whin
agin56132712agin
ahi68040232ahi_
ahing98928352ahing
ahis76135382ahis
ain37579092_ain
akin86328032akin
amin66042252amin
ayin76331742ayin
bin56658642_bin
blin67228172blin
brin67038192brin
cain65643912cain
chain105723672chain
chi86228652chi_
chia96026622chia
chic115925202chic
chid106626402chid
china105022482china
chine105231722chine
chink145321592chink
chino105823312chino
chins105631462chins
chip116726422chip
chis95933312chis
chit96937462chit
chon96627792chon
coin66645352coin
din46459462_din
djin12911632djin
ethic101511222ethic
ethion938812ethion
fain75840562fain
fin66458032_fin
foin77231562foin
gain56042162gain
ghi77019882ghi_
ghis85020162ghis
gin46055752_gin
grin55733722grin
hen67555272_hen
hi57947582_hi_
hic86540562_hic
hid76248382_hid
hie67652702_hie
him86247662_him
hind85529752_hind
hins76447992_hins
hint77455742_hint
hip86750432_hip
his66359502_his
hisn79620932_hisn
hit66569192_hit
hon67759382_hon
hun65844712_hun
in28150862__in
jin106443932_jin
join116724832join
kain85334292kain
khan115819142khan
khi106318302khi_
khis117017982khis
kin76353972_kin
lain46146282lain
lin37967372_lin
loin46838722loin
main65345522main
ohia75719362ohia
ohing96018812ohing
pain65647242pain
pein65834942pein
phi86524202phi_
phis95724902phis
phiz186718842phiz
phon95925382phon
pin57066722_pin
pyin96823232pyin
quin135823922quin
rain46251732rain
rein46040892rein
rhino84614322rhino
rin36663182_rin
ruin47430512ruin
sain45551292sain
shim95827862shim
shine85533092shine
shins85131042shins
shiny115122142shiny
ship95228242ship
shit76745942shit
shiv105721172shiv
shun75122772shun
sin36265892_sin
skin85927532skin
spin66231302spin
stain55727942stain
stein54620542stein
tahini939892tahini
tail45443652tail
tains54936322tains
taint55542282taint
takin94921302takin
tan37167582t_an
tarn46842722tarn
teen45938202teen
teind6213612teind
ten35856112t_en
tern46134802tern
thae76825562thae
thane86122532thane
thank125817802thank
that75639322that
thaw107521312thaw
the67436052th_e
thee78039062thee
thegn95810902thegn
theine94814922theine
theins95015422theins
their85512152their
them97427042them
thens85921832thens
thew108226232thew
they107223752they
thick145613352thick
thief114516302thief
thigh12410122thigh
thill85918732thill
things104914302things
thinks134613362thinks
thinly1238672thinly
thiol87616042thiol
third95912492third
thirl85416822thirl
tho67433962th_o
thong95014182thong
thorn85318702thorn
thou76722212thou
thrip103012182thrip
thro77726422thro
thru76818942thru
thud85613912thud
thug86415482thug
thunk124911852thunk
thus76721472thus
thy97022912th_y
ti28448292t_i_
tic56343462t_ic
tie36557532t_ie
til36350262t_il
tine45855132t_ine
ting56139912t_ing
tins45251302t_ins
tint46758862t_int
tiny76134632t_iny
tip56551222t_ip
tis37056642t_is
tit36771052t_it
toil46536282toil
toit46353062toit
ton310265102t_on
toon47740632toon
torn46044252torn
town76928702town
toxin124716712toxin
train56529112train
trig55528162trig
trim65329522trim
trine54734602trine
trio45233342trio
trip66830392trip
tui37034022tui_
tuis44829642tuis
tun35845192t_un
turn46330392turn
twain86313622twain
twig87615772twig
twine85822362twine
twins85118982twins
twiny116012812twiny
twit76329062twit
tying96019842tying
tyiyn11635332tyiyn
vain75233002vain
vein75625752vein
wain75840202wain
when105723042when
whid115418872whid
whig115516422whig
whim126220532whim
whine116022812whine
whins114922332whins
whiny144915572whiny
whip125521842whip
whir105519282whir
whit104834172whit
whiz195919942whiz
win66456292_win
within123611382within
yin67648732_yin
zein135620602zein
zin125643772_zin

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 Filter178691298720.296603685.8
2DLD Change Limit298722190.86034734.9
3Display Results2192190.0464760.9
 (SQL Overall)1786912191.202148661.4
 
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.