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

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

56 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
thiaminase155224(None) 
thiaminases1652361thiaminases
thiamine1346772thiamin__e
thiamines1446382thiamines_
thiamins1346632thiamin_s_
deaminase1245383_deaminase
histaminase1652153_histaminase
thiamin1236933thiamin___
thiazine2045253thiazin__e
thiazines2144643thiazines_
thiazins2045313thiazin_s_
amidase1036734___amidase
chamisas15317814ch_amisas_
chamise143612854ch_ami__se
criminate1348984cri_minate
deaminases1345284_deaminases
deaminate12410174_deaminate
delaminate1347374delaminate
diamine10311984_diamin__e
diamines11311644_diamines_
diamins10312214_diamin_s_
eliminate1147734eli_minate
glutaminase1451874glutaminase
histaminases1752114_histaminases
laminae93512974__lamina_e
laminas93615874__laminas_
laminate103014634__laminate
laminose1036914__laminose
rhamnose13103464rh_am_nose
staminas1048854_staminas_
staminate1187984_staminate
terminate11411204t_erminate
thanage11117944th_a__nage
thiazide2143034thiazi__de
thiazides2242784thiazides_
thiazin1945484thiazin___
thinkings17255054thinkings_
thionate11137504thi__onate
thionine1187924thionin__e
thionines12106974thionines_
thionins1177924thionin_s_
thymine1536644th_ymin__e
thymines1635614th_ymines_
timings10279304t_i_mings_
transaminase1453374transaminase
triazine1738504triazin__e
triazines1847544triazines_
triazins1738354triazin_s_
trichinae1444704trichina_e
trichinas1446044trichinas_
trimmings14254454trimmings_
tsarinas835274t_sarinas_
tyramine1347304tyramin__e
tyramines1447214tyramines_
tyrosinase1352444tyrosinase
tzarinas1733974t_zarinas_

Search took 10 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 Filter1786911614500.440406115.9
2DLD Change Limit161450569.37317225.0
3Display Results56560.0301866.7
 (SQL Overall)178691569.84318154.1
 
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.