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

66 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
titanate89716(None) 
titanates976081titanates
titanite898431titanite
titanites997412titanites
titivate1146802titivate
titrate72215572tit_rate
binate8419773bi__nate
catenate10312833catenate
citrate92216793cit_rate
cyanate12259703_cyanate
detonate9311193detonate
dilatate947773dilatate
divagate1344783divagate
emanate9312473_emanate
imamate1138093_imamate
innate63917313_i_nnate
intonate8310923intonate
iterate71119103_iterate
khanate1437073_khanate
lanate6421263__lanate
literate81216883literate
litigate948303litigate
mitigate1148693mitigate
nitrate72017013nit_rate
nizamate1943523nizamate
patinate103016313patinate
picante11310523pican_te
pinnate93613743pi_nnate
pitapat1149163pitapat_
pitapats1244443pitapats
planate9314573_planate
situate7410773sit_uate
stagnate947243_stagnate
sultanate946053sultanate
tannate71813523t_annate
tantalate9107363tantalate
ternate7415483t_ernate
tetanal738023tetana_l
tetanise8610203tetanise
tetanize17109953tetanize
thanage11117933t_hanage
thionate11137493thionate
tinplate1047733tinplate
tisane6311573tisan__e
titan53318173titan___
titaness836723titaness
titania738283titan_ia
titanias847103titanias
titanic968543titan_ic
titanism1048213titanism
titanium1046033titanium
titanous846543titanous
titans63414913titan__s
titillate945583titillate
titivated1345443titivated
titivates1246433titivates
titrant7315193titran_t_
titrants838483titran_ts
titrated92611683tit_rated
titrates82314643tit_rates
tittivate1243403tittivate
tribunate1144953tribunate
triturate947483triturate
vicarate1378603vicarate
vitiate103412953vit_iate
vittate10409723vit_tate

Search took 9 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 Limit146162668.33017546.5
3Display Results66660.0302200.0
 (SQL Overall)178691668.51620983.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.