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

65 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
titanous84655(None) 
bimanous1245692bimanous
gitanos837172gitano_s
tetanus737932tetan_us
tinamous1045982tinamous
titaness836722titaness
titanias847102titanias
titanium1046032titanium
titaniums1144762titaniums
titans63414912titan__s
bigamous1385503bigamous
biparous1246923biparous
biramous1266073biramous
butanols1044713butanols
chitinous1474993chitinous
citators10310253citators
citreous1056853citreous
citrous93112993cit_rous
cutaneous1144983cutaneous
digamous1296063digamous
gitano738043gitano__
litanies8310993litanies
melanous1048603melanous
miaous8511693mi_a_ous
mutinous1047653mutinous
nitinols844413nitinols
nitrous73512483nit_rous
octanols1044553octanols
petalous1058973petalous
pianos84315933pi_ano_s
pintanos10107553pintano_s
piteous9310683pit_eous
stannous846443_stannous
stanols739733_stanols
tamandus1143943tamandus
tantalous946193tantalous
tartarous946423tartarous
tetanics10127373tetanics
tetanies8513553tetanies
tetanoid947203tetanoid
timaraus1095073timaraus
timeous938403ti_meous
timorous1047433timorous
tinamou965013tinamou_
tisanes7311853tisan_es
titan53318173titan___
titanate897173titanate
titanates976093titanates
titania738293titan_ia
titanic968553titan_ic
titanism1048213titanism
titanisms1147423titanisms
titanite898433titanite
titanites997413titanites
titians72710453titian__s
titmouse1043133tit_mouse
titrants838483titran_ts
titrators948383titrators
trigonous1045303trigonous
turacous1047143turacous
tyrannous1243253tyrannous
uranous7310733_uranous
vinous93914173vi__nous
vitreous1145843vitreous
witans93412933witan__s

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162657.06020702.8
3Display Results65650.0331969.7
 (SQL Overall)178691657.24924650.4
 
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.