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

195 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
hacklier173713(None) 
hackler163512351hackl_er
cackler153812572cackl_er
cracklier1744822cracklier
darklier1335012darklier
hacker154822692hack__er
hackie154615622hack_ie_
hackies163418242hack_ies
hackle154916812hackl_e_
hackled173312482hackl_ed
hacklers173710302hackl_ers
hackles162917062hackl_es
hackliest1836522hackliest
hackling183310162hackling
haulier1059942ha_ulier
heckler16278572heckl_er
shackler17317972shackl_er
sicklier1457212sicklier
tackier133712522tack_ier
tackler134013322tackl_er
wackier16369732wack_ier
whackier2044672whack_ier
achier113914263_ac_hier
applier1137903_applier
atelier7311623_atelier
backbiter191786803backbiter
backer144525523back__er
backfire1946003backfire
backlist16910653backlist
backlit15911903backli_t
backslider1944183backslider
balkier134111983balk_ier
barkier133814483bark_ier
baulkier1433533baulkier
buckler154112033buckl_er
cackle143416923cackl_e_
cackled164613293cackl_ed
cacklers163710703cackl_ers
cackles153717203cackl_es
cackling172610943cackling
cakier123115243ca_k_ier
cavalier1348173cavalier
chalkier1736753chalk_ier
chuckler1935553chuckl_er
cockier154013623cock_ier
dacker134920753dack__er
dallier84215373da_llier
danglier1056753danglier
dickier143512453dick_ier
duckier143911793duck_ier
earlier72612743ea_rlier
fickler16348423fickl_er
frecklier1842993frecklier
gainlier965673gainlier
ganglier1047603ganglier
gasalier936443gasalier
gaselier946963gaselier
gasolier935833gasolier
gawkier15326523gawk_ier
ghastlier1342893ghastlier
hacked164923513hack__ed
hackee154921833hack__ee
hackees165014103hack_ees
hackers164619043hack__ers
hacking173720613hack_ing
hackly18298733hackl__y
hackmen1836713hack_men
hackney1935123hack_ney
haggler12328933haggl_er
hailer94720343ha_il_er
hairier103111053ha_irier
haler85033523ha__l_er
halter94420883ha__lter
hammier143510653ha_mmier
handier113817443ha_ndier
handler113516163handl_er
hanker134622093hank__er
hankerer15248233hankerer
hankie133915713hank_ie_
hankies143617763hank_ies
happier143312033ha_ppier
hardier114721543ha_rdier
harkener1537573harkener
harrier104417753ha_rrier
hastier103916623ha_stier
hauler95015123ha_ul_er
hauliers1176713ha_uliers
haulmier1333143haulmier
hawker164812663hawk__er
hawkie163810093hawk_ie_
hawkies173311243hawk_ies
hawklike1734493hawklike
hazier184712403ha__zier
heckle153112093heckl_e_
heckled17318463heckl_ed
hecklers17357123heckl_ers
heckles163711383heckl_es
heckling18257163heckling
hickie153812473hick_ie_
hickies163614743hick_ies
hillier103413963h_illier
hinkier143610793hink_ier
hocker155118563hock__er
hokier134214033h_ok_ier
holier94921623h__olier
homelier1338983homelier
hookier143811673hook_ier
hotelier1137633hotelier
huckle153913073huckl_e_
huckles163612623huckl_es
huckster1743823huckster
hulkier14328973hulk_ier
hunkier144512143hunk_ier
huskier14369753husk_ier
ickier12439913_ick_ier
jacker194417583jack__er
jackies202912623jack_ies
jackleg2135033jackl_eg
janglier1656113janglier
kickier12349053kick_ier
knucklier1442303knucklier
lacier84020093lac__ier
lacker125325623lack__er
lakier104716273la_k_ier
lankier113711633lank_ier
larkier113711523lark_ier
lavalier1146043lavalier
luckier133811533luck_ier
mackle143716433mackl_e_
mackled164111913mackl_ed
mackles154415753mackl_es
mackling172710063mackling
manlier92414023ma_nlier
marblier1256343marblier
marlier92614773ma_rlier
mickler153310233mickl_er
muckier153411473muck_ier
oakier104011393oa_k_ier
pacier105018683pac__ier
pacifier1557503pacifier
packager17136153packager
packer144223403pack__er
palier85023563pa__lier
pallier94417163pa_llier
pawkier16236613pawk_ier
peckier153910523peck_ier
pickier153912973pick_ier
pockier153911603pock_ier
pricklier17245063pricklier
quackier23215373quack_ier
racier85120973rac__ier
racker124824553rack__er
racketier15165413racketier
rackle123917293rackl_e_
rallier73816273ra_llier
rockier134911883rock_ier
sacker125124843sack__er
sacklike1337303sacklike
sallier73320423sa_llier
sarkier113413313sark_ier
scalier94316913_scalier
shackle16409543shackl_e_
shackled18277593shackl_ed
shacklers18336033shackl_ers
shackles173010593shackl_es
shackling19286173shackling
shakier143411153sha_k_ier
shalier103116423sha__lier
shapelier1444463shapelier
sicklied1546583sicklied
sicklies14710013sicklies
sparklier1554353sparklier
suckier133613973suck_ier
suckler133413093suckl_er
tacker124224503tack__er
tackifier1844143tackifier
tackle123815733tackl_e_
tackled143913183tackl_ed
tacklers143010773tackl_ers
tackles133816523tackl_es
tackling153211123tackling
talkier114011843talk_ier
tallier72817213ta_llier
tanglier948073tanglier
tickler133612653tickl_er
tinklier1255443tinklier
tricklier15256823tricklier
wabblier15375493wabblier
wacker154920123wack__er
wafflier1733953wafflier
wagglier1344323wagglier
wamblier15275733wamblier
weaklier1534263weaklier
whacker19368503whack__er
yuckier16358533yuck_ier

Search took 9 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.1731032896.0
2DLD Change Limit1461621957.86018595.7
3Display Results1951950.0762565.8
 (SQL Overall)1786911958.10922036.1
 
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.