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 “hackliest” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

119 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
hackliest183652(None) 
backlist16910652backli_st
crackliest1844882crackliest
darkliest1435162darkliest
hackies163418242hack_ies_
hackles162917062hackl_es_
hacklier1737132hacklie_r
sickliest1547512sickliest
tackiest143112432tack_iest
wackiest172610272wack_iest
whackiest2144982whack_iest
achiest12315183_ac_hiest
backless162910633backl_ess
backlight2155703backlight
backlists17117413backli_sts
backlit15911903backli__t
backrest1639393back_rest
balkiest144112453balk_iest
barkiest144115153bark_iest
baulkiest1544233baulkiest
blacklist1746123blackli_st
cackles153717203cackl_es_
cakiest133215663ca_k_iest
chalkiest1837083chalk_iest
checklist2043853checkli_st
cockiest163013293cock_iest
dangliest1137173dangliest
dickiest153412503dick_iest
duckiest153211863duck_iest
earliest82415243ea_rliest
ficklest17267903fickl_est
freckliest1943383freckliest
gainliest1037133gainliest
gangliest1137673gangliest
gawkiest16327313gawk_iest
ghastliest1443443ghastliest
hackees165014103hack_ees_
hackie154615623hack_ie__
hackle154916813hackl_e__
hackled173312483hackl_e_d
hackler163512353hackl_e_r
hacklers173710303hackl_ers
hackling183310163hackli_ng
hairiest11612463ha_iriest
halest94823273ha__l_est
hammiest152610003ha_mmiest
handiest123417773ha_ndiest
handlist12311333handli_st
hankies143617763hank_ies_
happiest152411673ha_ppiest
hardiest123416333ha_rdiest
hastiest112916493ha_stiest
haulmiest1443813haulmiest
hawkies173311243hawk_ies_
haziest193313003ha__ziest
heckles163711383heckl_es_
hickies163614743hick_ies_
hilliest113914113h_illiest
hinkiest153311753hink_iest
hokiest144114243h_ok_iest
holiest104319623h__oliest
homeliest1448553homeliest
hookiest152712103hook_iest
huckles163612623huckl_es_
hulkiest15329713hulk_iest
hunkiest153812333hunk_iest
huskiest153210413husk_iest
ickiest133611043_ick_iest
jackies202912623jack_ies_
jacklight2643743jacklight
jangliest1746383jangliest
kickiest13319673kick_iest
knuckliest1542543knuckliest
laciest93819033lac__iest
lakiest113517263la_k_iest
lankiest122912493lank_iest
larkiest123713313lark_iest
luckiest143011443luck_iest
mackles154415753mackl_es_
manliest102314943ma_nliest
marbliest1336763marbliest
marliest102415183ma_rliest
micklest16219123mickl_est
muckiest163210913muck_iest
oakiest112913923oa_k_iest
paciest112917803pac__iest
paliest93021603pa__liest
palliest102814633pa_lliest
pawkiest17277883pawk_iest
peckiest162711393peck_iest
pickiest162712593pick_iest
pockiest163412053pock_iest
prickliest1845293prickliest
quackiest2435183quack_iest
raciest92820013rac__iest
racketiest1643903racketiest
rockiest142912223rock_iest
sarkiest123615063sark_iest
scaliest101714383_scaliest
shackles173010593shackl_es_
shakiest151910933sha_k_iest
shaliest111415043sha__liest
shapeliest1544953shapeliest
sicklies14710013sicklies_
sparkliest1644553sparkliest
suckiest143314103suck_iest
tackles133816523tackl_es_
tackless14419483tackl_ess
talkiest123611223talk_iest
tangliest1068423tangliest
tinkliest1336133tinkliest
trickliest1646433trickliest
wabbliest16274963wabbliest
wackest164710863wack__est
waffliest1844223waffliest
waggliest1434783waggliest
wambliest16255153wambliest
weakliest1635853weakliest
yuckiest17328833yuck_iest

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.1561145455.1
2DLD Change Limit1486411196.46622988.1
3Display Results1191190.0462587.0
 (SQL Overall)1786911196.66826798.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.