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

132 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
tsks8641066(None) 
asks85721211asks
tasks94917581tasks
tsk75814731tsk_
tusks94915531tusks
arks85936872arks
ask77130702ask_
askos95011772askos
asps65622092asps
ass37844062as_s
auks85525262auks
basks115621762basks
bisks115416802bisks
bosks115218852bosks
busks115521372busks
casks115720062casks
cusks114916052cusks
daks97130602daks
desks105913072desks
disks105417472disks
dusks105317252dusks
elks85820032elks
eses45336102eses
ess36030882es_s
husks125015452husks
ilks87218572ilks
inks86926502inks
irks86220132irks
isms66213472isms
leks85427602leks
masks115320532masks
mosks116117002mosks
musks116119642musks
oaks86527902oaks
oses46641512oses
psis68120342psis
risks94917062risks
rusks95816192rusks
sis37360552_sis
ska76925862_ska
skas85325712_skas
ski74925702_ski
skis84825302_skis
sky106420992_sky
sos37761602_sos
suks85927122suks
tabs66842982tabs
tacks115430132tacks
tads57143952tads
tags55545242tags
taka87623592taka
takas95520682takas
take84739262take
takes94437792takes
talks94322692talks
tams67247932tams
tanks94624742tanks
tans46154832tans
taos45541002taos
taps66050682taps
tars46763952tars
tas38477102t_as
task85326652task_
tass45640572tass
tats46858132tats
taus46342732taus
tavs75630972tavs
taws75641592taws
teaks94222902teaks
teas45851492teas
teds54932582teds
tees45353582tees
tegs56031492tegs
tels46841692tels
tens45647412tens
tests56530192tests
tets45847462tets
tews76431642tews
this76027382this
thus76721472thus
ticks115823292ticks
tics65729642tics
ties45248322ties
tike85534492tike
tikes95628902tikes
tiki87620852tiki
tikis95615972tikis
tils45739622tils
tins45251312tins
tips66436772tips
tis37056652t_is
tits46145052tits
tods56141852tods
toes46956442toes
togs57242432togs
toke86738492toke
tokes95234972tokes
toms68343492toms
tons46553052tons
tops66248122tops
tors46157382tors
torsks10549122torsks
toss45637972toss
tots46654122tots
tows78545552tows
toys78036342toys
treks96016852treks
tres46542902tres
tsar47819802tsar
tsars56717112tsars
tsked105910032tsked
tsktsk94892tsktsk
tubs65430062tubs
tucks114721122tucks
tugs56231672tugs
tuis44829642tuis
tuns45138662tuns
tups65628762tups
turks95320822turks
tusk85621632tusk_
tuts45838452tuts
twas76824082twas
twos76718022twos
tyes76433372tyes
tyke115720502tyke
tykes125817062tykes
uses44931112uses
woks116224902woks
yaks116025202yaks
yoks116223742yoks
yuks116418022yuks
zeks175815062zeks

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.280638182.1
2DLD Change Limit298721320.81336742.9
3Display Results1321320.0462869.6
 (SQL Overall)1786911321.139156884.1
 
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.