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

59 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
coattail104531(None) 
cattail939181c_attail
coattails1144851coattails
cattails1038552c_attails
coastal9411042coasta_l
cocktail1645362cocktail
contrail10410982contrail
rattail737802_rattail
attain6311753__attain
bobtail1146553bo_btail
brantail1046893brantail
broadtail1243123broadtail
camail10314833c_a_mail
cantal84122033c_anta_l
captain112111063c_aptain
catcall1139153c_atcall
catfall1237393c_atfall
cattalo938423c_attalo
cattie85221023c_att_ie
cattily123210853c_att_ily
chaetal1238283chaeta_l
chattel12388893chatt_el
chattily1634603chatt_ily
coaeval1245183coaeva_l
coastally1446503coastally
coati75624643coa_t_i_
coatis85122603coa_t_is
coatrack1645853coatrack
coattend1134653coattend
coattest1038863coattest
coaxal15387303coa_xa_l
coaxial16157003coaxia_l
cocaptain1543663cocaptain
cocktails1744933cocktails
coistril1046763coistril
coital84117053co_ita_l
comitial1248693comitial
contain9315833co_ntain
contrails11410543contrails
costal85419513co_sta_l
cotta75818573co_tta__
cottae84615703co_tta_e
cottage104210573co_ttage
cottar84613813co_tta_r
cottars94412243co_ttars
cottas84615573co_tta_s
cottontail1251973cottontail
curtail9299663c_urtail
dovetail1244393dovetail
fantail10310233_fantail
foxtail1745383fo_xtail
horntail11105033horntail
mocktail1643673mocktail
outsail71411413_outsail
oxtail1337653_o_xtail
ponytail1344553ponytail
rattails837133_rattails
reattain846733reattain
wagtail1145043_wagtail

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.423422437.4
2DLD Change Limit146162597.67319048.9
3Display Results59590.0301966.7
 (SQL Overall)178691598.12621990.0
 
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.