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

56 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
thickener184416(None) 
thickened1944301thickened
thickeners1943461thickeners
chickened2144622chickened
quickener2443122quickener
sickener1436602_sickener
slickener1544042slickener
thicken16317872thicken__
thickens17266412thicken_s
thicker163611022thick__er
thicketed1943612thicketed
bickerer16106773_bickerer
blackener1754973blackener
chicaner1586073chic_aner
chickee183111553chicke_e_
chickees19258513chicke_es
chicken18278983chicken__
chickens19267433chicken_s
cricketer1744563cricketer
harkener1537573_harkener
pickeer153710113_picke_er
picketer16187433_picketer
quickened2543163quickened
quickeners2542763quickeners
shicker163914823shick__er
shickered19115723shickered
sickened1546783_sickened
sickeners1535733_sickeners
slackener1543933slackener
slickened1644293slickened
slickeners1643663slickeners
snickerer15134563snickerer
thickening2043283thickening
thickest17337303thicke_st
thicket163213073thick__et
thickets17287083thicke_ts
thickety20274103thicke_ty
thickness1844443thickness
thickset17257133thick_set
thinker143610683think__er
thinner10358973thi__nner
ticker124321503t_ick__er
ticketed15146643t_icketed
tickler133612653t_ick_ler
tinkerer1286803t_inkerer
tricker134615523trick__er
trickier143010233trick_ier
tricklier15256823tricklier
tricksier15275243tricksier
trickster15265703trickster
trinketer1344563trinketer
whichever2341903whichever
whicker19359773whick__er
whickered22114033whickered
whitener1435733whi_tener
wickeder1843983_wickeder

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 Filter1786911486410.423422437.4
2DLD Change Limit148641566.04624585.0
3Display Results56560.0163500.0
 (SQL Overall)178691566.48527554.5
 
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.