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

62 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
thickened194430(None) 
chickened2144621chickened
thickener1844161thickener
thicketed1943611thicketed
quickened2543162quickened
shickered19115722shickered
sickened1546782_sickened
slickened1644292slickened
thicken16317872thicken__
thickeners1943462thickeners
thickens17266412thicken_s
ticketed15146642t_icketed
whickered22114032whickered
bickered17108003_bickered
blackened1845273blackened
checkered2144683checkered
chicaned1665873chic_aned
chickee183111553chicke_e_
chickees19258513chicke_es
chicken18278983chicken__
chickens19267433chicken_s
chickweed2443163chickweed
cricketed1854683cricketed
dickered16117533_dickered
flickered1943753flickered
harkened1637483_harkened
lichened1435753_lichened
likened12267353_li_kened
nickeled15115513_nickeled
nickered15117023_nickered
picketed17167383_picketed
pinkened1535753_pinkened
quickener2443123quickener
richened1435953_richened
sickener1436603_sickener
slackened1644243slackened
slickener1544043slickener
snickered16115343snickered
thacked173810203thack__ed
thickening2043283thickening
thicker163611023thick__er
thickest17337303thicke_st
thicket163213073thick__et
thickets17287083thicke_ts
thickety20274103thicke_ty
thickhead2242693thickhead
thickheaded2551483thickheaded
thickness1844443thickness
thickset17257133thick_set
thieved1434973thi__eved
thinned11399163thi__nned
ticked134720523t_ick__ed
tickled144313133t_ick_led
tickseed1584513t_ickseed
tinkered1387683t_inkered
tokened1236393t__okened
tricked144016163trick__ed
trickled152610433trick_led
trinketed1444253trinketed
tuckered1535963t_uckered
whiskered20123393whiskered
whitened1535173whi_tened

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.470380193.6
2DLD Change Limit148641627.39020113.8
3Display Results62620.0331878.8
 (SQL Overall)178691627.89322639.2
 
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.