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

50 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
coattests114346(None) 
coattest1038861coattest_
attests7278812__attests
coatless1039692coatles_s
coattends1243912coattends
coattested1342972coattested
contests103413382co_ntests
posttests1144972posttests
attest62618613__attest_
cathects1545793c_athects
cattiest103016333c_attiest_
chartists14126803chartists
chastest1349703chastest_
chattels13286793chatte_ls
chatters134213953chatte_rs
chattiest1448203chattiest_
clatters103313913clatte_rs
coagents1138453coa_gents
coaliest10316223coaliest_
coalless1038193coalles_s
coarsest1039163coarsest_
coassists11275763coassists
coasters104317333coaste_rs
coasts85719143coa___sts
coatdress1243193coatdres_s
coatees93816553coa_te_es
coaters93525793coa_te_rs
coattails1144853coattails
coattend1134653coatte_nd
coattesting1443453coattesting
congests113510383co_ngests
conquests2045363conquests
contents104018213co_ntents
contest93523233co_ntest_
contexts17378653co_ntexts
contrasts112211043contrasts
costless10310003costles_s
cotters94323443co_tte_rs
countess103710053countes_s
couthest13312083couthest_
fattest102913063_fattest_
flattest1138713flattest_
footrests12244503footrests
hottest10411383ho_ttest_
latests73910313_la_tests
mostests1036833mo_stests
obtests9136233_o_btests
phattest1336913phattest_
posttest10410233posttest_
wattest102412153_wattest_

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 Filter1786911486410.1701051123.5
2DLD Change Limit148641507.12620859.0
3Display Results50500.0133846.2
 (SQL Overall)178691507.30924448.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.