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

137 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
whammies1826551(None) 
chammies172910161chammies
shammies15259691shammies
cammies134016482_cammies
chammied18215972chammied
hammier143510652_hammier
hammiest152610012_hammiest
jammies183611292_jammies
mammies104314762_mammies
shammes144312832shamm_es
shammied16265542shammied
shimmies15287802shimmies
tammies113814682_tammies
whammed18345132whamm_ed
whamming19275222whamming
whimsies1635192whimsies
amies76837693__a_mies
ammines11312673__ammines
armies85123693__armies
cammie124615293_cammie_
challies133915643challies
chamades16138653chamades
chamise143612853cha_mise
chamises153513313chamises
chamois143512193chamoi_s
chamoises16327933chamoises
chamomiles1953503chamomiles
chanties132615803chanties
chappies172610103chappies
charlies133414233charlies
chummier1734513chummier
chummiest1834643chummiest
clammier1435843clammier
clammiest1535743clammiest
commies133718453_commies
crummies1437643crummies
dummies123012133_dummies
gammier123711193_gammier
gammiest13339333_gammiest
gharries12318213gharries
ghazies2036913gha_zies
gimmies123010113_gimmies
grammes123611323gramm_es
gremmies1355993gremmies
hackies163418243_hackies
haemins122811403_haemins
hamates122917683_hamates
hames106138703_ha_m_es
hammals14409233_hammals
hammams13386443_hammams
hammed144116973_hamm_ed
hammer138120033_hamm_er
hammers144216063_hammers
hammily1736063_hammily
hamminess1635713_hamminess
hamming153014093_hamming
hankies143617763_hankies
hardies114923233_hardies
harmines132715143_harmines
harmins123716723_harmins
harpies123818323_harpies
harries103525493_harries
hawkies173311243_hawkies
homies114524733_h_omies
immies102412443__immies
jammier18408023_jammier
jammiest19307203_jammiest
jemmies18318333_jemmies
jimmies18328783_jimmies
khamsins1743393khamsins
lambies113015113_lambies
mamies104626243_ma_mies
mammees104411143_mammees
mammie94313783_mammie_
mommies103912273_mommies
mummies103812843_mummies
phasmids16195183phasmids
pommies133712843_pommies
psammites1542843psammites
ramies84630463_ra_mies
rammier112811023_rammier
rammiest12299933_rammiest
rummies113212793_rummies
scampies1439333scampies
shambles15159043shambles
shames114726223sha_m_es
shammas14358723shamm_as
shammed153911423shamm_ed
shammer144613143shamm_er
shammers153710843shammers
shamming16289413shamming
shammos14307203shamm_os
shamois123210423shamoi_s
shamuses1336153shamuses
shandies122714113shandies
shannies113411263shannies
shanties113116593shanties
sharpies13411233sharpies
shavies134213213sha_vies
shimmied16294983shimmied
swamies123712063swa_mies
tammie104212693_tammie_
tommies113812983_tommies
tummies113012033_tummies
waddies124214753w_addies
wadies105121203w_a_dies
waffies163611443w_affies
walies95324523w_a_lies
wallies103320743w_allies
wambles143714023w_ambles
wames106432803w_a_m_es
wammus13426733w_amm_us
wammuses1543493w_ammuses
wamuses1237023w_amuses
wavies125019843w_a_vies
wearies103020223wea_ries
whackier2044673whackier
whackiest2144993whackiest
whales124716943wha__les
whammo16405193whamm__o
whammy19375293whamm__y
whams135515643wha_m__s
whangees15275063whangees
wharves16457133wha_rves
whatsis1335253whatsi_s
whatsises1543203whatsises
whatsits1443543whatsits
wheelies1437863wheelies
wherries14179023wherries
whimsied1743113whimsied
whinnies14237273whinnies
whirlies14167373whirlies
whirries14136693whirries
whiskies1835953whiskies
whities133113253wh_ities
whoopies16267373whoopies
yummies14359533_yummies

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.423422437.4
2DLD Change Limit1461621376.57622226.6
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.04525364.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.