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

214 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
whackier204467(None) 
wackier16369731w_ackier
whacker19368501whack_er
chalkier1736752chalkier
hacker154822692_hack_er
hackie154615622_hackie_
hackies163418242_hackies
hackler163512352_hackler
hacklier1737132_hacklier
quackier23215372quackier
shackler17317972shackler
shakier143411152sha_kier
tackier133712522_tackier
wacker154920122w_ack_er
whacked20458622whack_ed
whackers20326542whack_ers
whackiest2144982whackiest
whacking21377482whacking
whelkier1833252whelkier
whicker19359772whick_er
achier113914263__achier
backer144525523_back_er
balkier134111983_balkier
barkier133814483_barkier
beachier1538803beachier
beakier134012163bea_kier
blacker154513513black_er
blockier1666133blockier
brakier133812363bra_kier
brickier16307163brickier
cackler153812573_cackler
cakier123115243_ca_kier
chaffier1935473chaffier
chancier1538823chancier
charier124317903cha_rier
charrier1378683charrier
chattier1337513chattier
checker18329533check_er
cheekier1735103cheekier
chichier1836023chichier
chinkier17377363chinkier
chokier1638043ch_okier
chuckies1937703chuckies
chuckler1935553chuckler
chunkier17395883chunkier
clacker153813773clack_er
clankier14327083clankier
cockier154013623_cockier
cracker153114173crack_er
cracklier1744823cracklier
crankier14339163crankier
dacker134920753_dack_er
dickier143512453_dickier
duckier143911793_duckier
flakier143910203fla_kier
flockier1745343flockier
gawkier15326523_gawkier
glacier103911293glac_ier
hacked164923513_hack_ed
hackee154921833_hack_ee
hackees165014103_hackees
hackers164619043_hack_ers
hacking173720613_hacking
hackle154916813_hackle_
hackled173312483_hackled
hacklers173710303_hacklers
hackles162917063_hackles
hackmen1836713_hackmen
hackney1935123_hackney
hairier103111053_hairier
hammier143510653_hammier
handier113817443_handier
hanker134622093_hank_er
hankie133915713_hankie_
hankies143617763_hankies
happier143312033_happier
hardier114721543_hardier
harrier104417753_harrier
hastier103916623_hastier
haulier1059943_haulier
hawker164812663_hawk_er
hawkie163810093_hawkie_
hawkies173311243_hawkies
hazier184712403_ha_zier
heckler16278573_heckler
hickie153812473_hickie_
hickies163614743_hickies
hinkier143610793_hinkier
hocker155118563_hock_er
hokier134214033_h_okier
hookier143811673_hookier
hulkier14328973_hulkier
hunkier144512143_hunkier
huskier14369763_huskier
ickier12439923__ickier
jacker194417583_jack_er
jackies202912623_jackies
kickier12349053_kickier
knacker12307913knack_er
lacier84020093_lac_ier
lacker125325623_lack_er
lakier104716273_la_kier
lankier113711633_lankier
larkier113711523_larkier
leachier1337253leachier
leakier114010993lea_kier
luckier133811533_luckier
muckier153411483_muckier
oakier104011393_oa_kier
pacier105018683_pac_ier
packer144223403_pack_er
pawkier16236613_pawkier
peachier1548623peachier
peakier134411443pea_kier
peckier153910523_peckier
pickier153912973_pickier
pluckier16295073pluckier
poachier1556823poachier
pockier153911603_pockier
prickier16368143prickier
quakier20239203qua_kier
racier85120973_rac_ier
racker124824553_rack_er
rockier134911883_rockier
sacker125124843_sack_er
sarkier113413313_sarkier
shabbier1535183shabbier
shacked174015393shack_ed
shacking184014083shacking
shackle16409543shackle_
shackled18277603shackled
shacklers18336033shacklers
shackles173010593shackles
shackoes17367853shackoes
shadier113111153sha_dier
shaggier13116053shaggier
shaker134319463sha_k_er
shalier103116423sha_lier
sharker144313813shark_er
shicker163914823shick_er
shlockier1842583shlockier
shocker163411433shock_er
shtickier1843163shtickier
shucker163710103shuck_er
skankier11184883skankier
slacker133915293slack_er
smacker153410583smack_er
snacker133112603snack_er
snakier112810003sna_kier
snarkier12336513snarkier
spacier114011633spac_ier
sparkier14298033sparkier
stacker134416263stack_er
stalkier1257073stalkier
stickier14229763stickier
stockier14217253stockier
suckier133613973_suckier
swankier15225503swankier
tacker124224503_tack_er
tackler134013323_tackler
talkier114011843_talkier
thacked173810203thack_ed
thacking183110043thacking
thanker14309593thank_er
thatchier1743983thatchier
thicker163611023thick_er
thwacker2042873thwack_er
tracker133515173track_er
trickier143010233trickier
tweakier1533143twea_kier
wacke145918623w_ack_e_
wackes154717713w_ack_es
wackiest172610273w_ackiest
wackily1936053w_ackily
waker125526593w_a_k_er
walker133913993w_alk_er
wanier93920683w_a_nier
wanker134219973w_ank_er
warier93722893w_a_rier
wartier103413913w_artier
washier133611153w_ashier
waspier12259053w_aspier
wavier124613083w_a_vier
waxier16439903w_a_xier
weaker134015443wea_k_er
weaklier1534263weaklier
wearier103613283wea_rier
whack174813023whack___
whacko18477033whack__o
whackos19375263whack_os
whacks184610483whack__s
whacky21556493whack__y
whaler124611973wha__ler
whammies18265513whammies
whapper17348273wha_pper
whatever1742673whatever
wheezier2333343wheezier
whickers20297983whick_ers
whinier134110633wh_inier
whinnier14255003whinnier
whippier18265823whippier
whirlier14175293whirlier
whisker17367933whisk_er
whiskies1835953whiskies
whitier133311063wh_itier
whizzier2233283whizzier
wicker154518673w_ick_er
witchier16307883witchier
wonkier1437423w_onkier
wracked174110113wrack_ed
wracking18349963wracking
wrathier1435903wrathier
wrecker16367603wreck_er
yuckier16358533_yuckier

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.1561145455.1
2DLD Change Limit1461622148.57617043.1
3Display Results2142140.0802675.0
 (SQL Overall)1786912148.81220278.1
 
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.