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

44 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
tsatske114183(None) 
tsatskes1242011tsatskes
tsetse664692tsets_e
tsktsk94892tsktsk_
tsktsked124642tsktsked
tsktsks104982tsktsks
isatine7311763isatine
latke94817093_lat_ke
sake85244963_sa__ke
sate45556103_sat__e
satire63218003_satire
stake95927533_s_take
state56237333stat__e
statice92614033statice
stative102612933stative
stats55933363stats__
statue66015323stat_ue
stature74410683stature
statute7419323statute
stoke94922513_s_toke
take84739263t_a__ke
task85326653t_a_sk_
tasked114714643t_a_sked
tasks94917583t_a_sks
tasse54821843t_a_sse
tassie66017023t_assie
taste55127233t_a_ste
tate44748603t_at__e
tats46858133t_ats__
tatsoi637263t_atsoi
tattie64817513t_attie
tattle64115653t_attle
tawse85616503t_aws_e
teacake1335453teacake
tealike111111083tealike
tease55428713tea_s_e
teatime9310083teatime
teats55636813teats__
tootsie737133tootsie
tsade64311123tsa__de
tsars56717113tsars__
tsetses785453tsetses
twats86616603twats__
twattle1064273twattle

Search took 8 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 Filter1786911340270.436409841.7
2DLD Change Limit134027447.25318478.8
3Display Results44440.0133384.6
 (SQL Overall)178691447.70223200.6
 
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.