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 “tsktsk” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

68 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
tsktsk9489(None) 
tsktsks104981tsktsks
tsatske1141832tsatske
tsetse664692tsetse
tsks86410662tsk_s_
tsktsked124642tsktsked
askos95011773askos_
asks85721213ask_s_
muktuk1142883muktuk
sets45549503_sets_
shtik123210963_shtik
sits45050203_sits_
skank84415583_skank
skas85325713_skas_
skats94621543_skats_
skink85916853_skink
skis84825293_skis_
skits94721863_skits_
skosh12407273_skosh
skulk8479623_skulk
skunk85011763_skunk
sots45552453_sots_
stats55933363stats_
stets55423913stets_
stots54828553stots_
tacts76524123tacts_
takas95520683takas_
takes94437793takes_
tarts57242023tarts_
task85326653t__ask
tasks94917583task_s_
tats46858133t_ats_
tauts56125513tauts_
teats55636813teats_
tents56434213tents_
tests56530193tests_
tets45847463t_ets_
texts125515043texts_
tikes95628903tikes_
tikis95615973tikis_
tilts55325613tilts_
tints56030923tints_
tits46145043t_its_
tofts84919243tofts_
toits55327473toits_
tokes95234973tokes_
toots55331873toots_
tootsy9437983tootsy
torsk94915773t_orsk
torts56138123torts_
tots46654123t_ots_
touts54830393touts_
trets55928023trets_
trots56629943trots_
tsars56717113tsars_
tsatskes1242013tsatskes
tsetses785453tsetses
tsk75814733___tsk
tsked105910033tsk_ed
tsking114210423tsking
tsktsking134933tsktsking
tufts85713273tufts_
tusk85621633t__usk
tusks94915533tusk_s_
tuts45838453t_uts_
twats86616603twats_
twits86015793twits_
tykes125817063tykes_

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit112716685.58020200.0
3Display Results68680.0302266.7
 (SQL Overall)178691686.00029781.8
 
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.