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

146 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
tsk7581473(None) 
ask77130701ask
task85326651task
tsks86410661tsks
tusk85621631tusk
ark77044962ark
as211083072as_
ash67944602ash
asks85721212asks
asp57235342asp
ass37844062ass
auk76234142auk
bask105131422bask
bisk106523352bisk
bosk105825732bosk
busk105429222busk
cask105626432cask
cusk105521632cusk
dak86340692dak
desk95618902desk
disk96625832disk
dusk95724152dusk
eek77935102eek
elk76726122elk
es29048222es_
ess36030882ess
husk116021952husk
ick97329322ick
ilk78325302ilk
ink76433632ink
irk76426362irk
is27048212is_
ism56322382ism
its35538832its_
lek75640302lek
mask105227362mask
mosk105622442mosk
musk104526192musk
oak76238652oak
os211359882os_
ose38147342ose
psi56621622psi
pst57932512pst
risk85724102risk
rusk85823312rusk
sh56828522_sh
si29149572_si
ska76925862_ska
ski74925692_ski
sky106420992_sky
so28855442_so
sty66227312sty
suk75632972suk
ta211662452t_a
tab57460322tab
tack106536292tack
tad47959822tad
tae38267052tae
tag47259502tag
taj106442192taj
taka87623592taka
take84739262take
talk86230092talk
tam58663422tam
tan37167582tan
tank85134032tank
tao38358952tao
tap57663882tap
tar37570692tar
tas38477102tas
tasks94917582tasks
tass45640572tass
tat37690292tat
tau36856902tau
tav66043212tav
taw610155452taw
tax109449152tax
tea37353322tea
teak85930842teak
ted46446562ted
tee38366872tee
teg45741622teg
tel35647902tel
ten35856112ten
test48651622test
tet39274992tet
tew66640152tew
the67436052the
tho67433962tho
thy97022912thy
ti28448292t_i
tic56343462tic
tick106231222tick
tie36557532tie
tike85534482tike
tiki87620842tiki
til36350262til
tin36362172tin
tip56551222tip
tis37056642tis
tit36771052tit
to218858982t_o
tod49457072tod
toe310166852toe
tog410255042tog
toke86738492toke
tom514358052tom
ton310265102ton
too38965422too
took86531072took
top510560682top
tor39261682tor
torsk94915772torsk
tosh74826812tosh
toss45637972toss
tost48351922tost
tot38884772tot
tow610557362tow
toy69655192toy
trek86222312trek
try66529672try
tsar47819802tsar
tsked105910032tsked
tub55640032tub
tuck104626572tuck
tug45937402tug
tui37034022tui
tun35845192tun
tup56037542tup
turk86125862turk
tush74523902tush
tusks94915532tusks
tut36758092tut
tux105426572tux
twa67721642twa
two67925832two
tye65837442tye
tyke115720502tyke
us26937432us_
use36835162use
uts35534372uts_
wok106334172wok
yak107038562yak
yok107335242yok
yuk106725602yuk
zek167323162zek

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 Filter178691140840.610292936.1
2DLD Change Limit140841461.31310726.6
3Display Results1461460.0463173.9
 (SQL Overall)1786911461.96990752.2
 
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.