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

49 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
tything14316571tything
kything18285522kything
tithing113513892tithing
anything1534993anything
bathing134816243bathing
bethink1677203bethink
kithing153411553kithing
lathing114315693lathing
mythic1637273mythi_c
mythier15125183mythier
nothing113511903nothing
pithing134014053pithing
python1447143python_
pythons1537363pythons
rethink1488883rethink
scything17264883scything
tahini939893t_ahini
tatting84019523tatting
teething1237163teething
thigh12410123__thigh
thin76732393__thin_
thine85026863__thine
thing96622983__thing
think125018803__think
thins85826333__thins
tithings12327693tithings
titling83715793titling
toothing12278863toothing
toting74123793tot_ing
totting82816843totting
trithing122811773trithing
trothing122410843trothing
tushing114214013tushing
tutting83515913tutting
tyin76424003ty__in_
tying96019843ty__ing
tyning105510413ty_ning
typhon1436673typhon_
typhons1537083typhons
typing124110583ty_ping
tyring104613023ty_ring
tythe115210453tyth__e
tythed13457503tyth_ed
tythes12419703tyth_es
unthink1457003unthink
within123611383within_
withing143814493withing
withins133511693withins
wyting13277243wyt_ing

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 Filter1786911340270.406440125.6
2DLD Change Limit134027495.68623571.4
3Display Results49490.0163062.5
 (SQL Overall)178691496.10829255.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.