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

45 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
tracheated164633(None) 
tracheate1448231tracheate_
tracheates1547921tracheates
brachiated1844672brachiated
racheted14149502_rache_ted
trabeated1246842tra_beated
tracheae1349112trachea_e_
brachiate1646873brachiate_
brachiates1746353brachiates
bracketed1855863bracke_ted
bracteate1345353bracteate_
cacheted16148233_cache_ted
cheated134416343___cheated
crocheted1745313croche_ted
escheated1546273_escheated
outcheated1645253outcheated
preheated1539813pr_eheated
procreated1546443procreated
racketed15169123_racke_ted
ratcheted1554783_ratche_ted
recreated12412533_recreated
reheated122415003_r_eheated
sacheted14127833_sache_ted
trabeate1049483tra_beate_
traceried1247143trac_eried
trachea12311683trachea___
tracheal1348253trachea__l
tracheary1744803trachea_ry
tracheas13410273trachea__s
tracheid1437583trache__id
tracheitis1543923tracheitis
tracheole1445573tracheole_
tracheoles1545623tracheoles
trachled1438313trach__led
trachyte1645943trach_yte_
trachytes1745923trach_ytes
tractate10411003trac_tate_
tractates1159763trac_tates
trajected1944043tra_jected
transected1347313transected
translated1149293translated
trapnested1343283trapnested
treated83618703tr___eated
truehearted1552523truehearted
ultraheated1553723ultra_heated

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 Filter1786911406030.406440125.6
2DLD Change Limit140603455.71624598.1
3Display Results45450.0162812.5
 (SQL Overall)178691456.13829112.3
 
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.