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

258 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
hankered1628944(None) 
cankered153010221cankered
hankerer15248231hankerer
hunkered16186921hunkered
angered93013472_angered
bannered11299322bannered
bantered113313632bantered
bunkered15177182bunkered
cancered132411552cancered
cantered113415982cantered
dackered16116892dackered
daikered1495222daikered
dandered112110962dandered
dangered11248512dangered
gandered112211172gandered
haltered123112552haltered
hammered16218842hammered
hampered16239922hampered
hangared1337562hangared
hanked144220602hank__ed
hanker134622092hanker__
hankerers16226712hankerers
hankers144218132hanker_s
hanseled1237712hanseled
harkened1637482harkened
havered144011452ha_vered
hawkeyed2242402hawkeyed
hindered1339452hindered
hungered13217052hungered
lackered15108672lackered
mannered11249652mannered
pandered121812572pandered
tinkered1387682tinkered
wandered132110792wandered
adhered1239233_adhered
altered83215733_altered
aneared8512743_aneared
aneled74719273_an_eled
angeled93211493_angeled
ankled114313473_ank_led
annexed1535753_annexed
answered1235483_answered
anteed75616113_ante_ed
antired82316193_antired
antlered938253_antlered
badgered1336213badgered
banked135021443bank__ed
banker124222733banker__
bankerly1744333bankerly
bankers133919093banker_s
banneret102412473banneret
banterer102811773banterer
barbered13259543barbered
bartered113113013bartered
battered113315053battered
bickered17108003bickered
blanketed1643913blanketed
blinkered1644413blinkered
brokered1536083brokered
cambered15128993cambered
canceled13279393canceled
canker124422523canker__
cankers134418753canker_s
capered123014043ca_pered
careered1139493careered
casketed1534953casketed
catered103117763ca_tered
centered112513523centered
chaffered21154473chaffered
chambered19145983chambered
chamfered20165053chamfered
channeled1544913channeled
chaptered17176783chaptered
chartered15158383chartered
chattered15197983chattered
checkered2144683checkered
chuntered1536653chuntered
cindered1239793cindered
clinkered1634773clinkered
cockered17710213cockered
daggered12246403daggered
danker114319663danker__
darkened1435943darkened
daundered1294423daundered
dickered16117533dickered
donnered10307753donnered
entered82718883_entered
faltered122810983faltered
fathered151510433fathered
fendered13258673fendered
fingered13128333fingered
garnered10247113garnered
gartered10319583gartered
gathered13149373gathered
gendered11258873gendered
gingered11127743gingered
glandered1236333glandered
hachured1744393hachured
hacked164923513hack__ed
hackee154921833hacke_e_
hackees165014103hacke_es
hacker154822693hacker__
hackers164619043hacker_s
hackled173312483hack_led
hackneyed2242233hackneyed
haeres94017033ha__eres
haired105117173ha__ired
hakeem15407383ha_ke_em
halberd1336043halber_d
haltere103614703haltere_
halteres113414593halteres
hammerer15278143hammerer
hamperer15379093hamperer
handed114919983han__ded
hander104526433hander__
handers114224333hander_s
handled124114533han_dled
handseled1444403handseled
hanged114222393han__ged
hanger104023253hanger__
hangers113120813hanger_s
hankering17239383hankering
hankie133915713hank_ie_
hankies143617763hank_ies
hanselled1345473hanselled
hanted104124313han__ted
happened1635653happened
harbored1438633harbored
hardened1338613hardened
hared95742183ha___red
harked145422553hark__ed
harkener1537573harkener
hastened12239103hastened
hatred104814333ha__tred
havened14429243ha_vened
haverel13397153ha_verel
hawked174712673hawk__ed
hawker164812663hawker__
hawkers174210333hawker_s
hawkweed2242203hawkweed
hayseed1435633hayse_ed
hearkened1744453hearkened
heathered16149463heathered
hinderer1238273hinderer
hollered1237603hollered
homered133212713h_omered
honeyed1437773hon_eyed
honked144517913honk__ed
honker134117463honker__
honkers143315233honker_s
honored11310123hon_ored
honoured1236313honoured
hoovered15195413hoovered
hovered143411573h_overed
hundred1237143hun_dred
hunker133917673hunker__
hunkers143314333hunker_s
inhered11313163_inhered
jabbered2034433jabbered
jacketed22146533jacketed
junketed2033523junketed
kashered1636403kashered
knackered1543683knackered
laagered1055853laagered
lackeyed18104513lackeyed
laddered1136743laddered
lagered92311153la_gered
lakebed1434783la_kebed
lanceted1137073lanceted
lanker104123003lanker__
lanneret82512363lanneret
lappered13288213lappered
lathered121512323lathered
laundered1185023laundered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
lingered10129643lingered
mackerel1644863mackerel
mammered12237653mammered
manured1039473man_ured
marketed1537323marketed
mastered112614003mastered
mattered112412903mattered
maundered1394943maundered
meandered1346143meandered
mongered1238953mongered
monkeyed1844153monkeyed
nankeen1135043nanke_en
nattered92011623nattered
nickered15117023nickered
packeted17148283packeted
paltered113012483paltered
pampered15229223pampered
panderer112210913panderer
paneled10612573pan_eled
panniered1243853panniered
papered122513163pa_pered
pattered112714203pattered
paupered13216933paupered
pinkened1535753pinkened
pondered126411293pondered
puckered1736103puckered
racketed15169123racketed
raftered1237663raftered
rancored1137223rancored
ranked114620743rank__ed
ranker105021903ranker__
rankers113217463ranker_s
rankled123910653rank_led
rapiered1136053rapiered
rendered102512263rendered
sabered103213023sa_bered
saggered11237553saggered
sauntered1036283sauntered
shanked153212123shank__ed
shattered13178203shattered
shickered19115723shickered
sintered92213903sintered
slandered1137473slandered
sneered83113973_sneered
suckered1537833suckered
sundered10312153sundered
tabered103311593ta_bered
tampered13279463tampered
tankard1267263tankar_d
tanked113919293tank__ed
tanker104521123tanker__
tankers113416913tanker_s
tapered102612933ta_pered
tattered92011443tattered
tendered102510603tendered
tentered96412103tentered
thanked15469153thank__ed
thanker14309593thanker__
thankers15297833thanker_s
thundered1444573thundered
tinkerer1286803tinkerer
tuckered1535963tuckered
veneered1235983veneered
wafered14288433wa_fered
wagered12299333wa_gered
waitered1238753waitered
wakened1546873wa_kened
wanderer122210123wanderer
wanked144517153wank__ed
wanker134219973wanker__
wankers144514713wanker_s
watered113014953wa_tered
wavered142910433wa_vered
whickered22114033whickered
whiskered20123393whiskered
wintered122111573wintered
wondered13239943wondered
yabbered1633963yabbered
yammered16225763yammered
yanked144312243yank__ed
yattered12239533yattered

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 Filter1786911461620.220812231.8
2DLD Change Limit1461622586.67021913.3
3Display Results2582580.1102345.5
 (SQL Overall)1786912587.00025527.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.