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

198 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
crummies143764(None) 
crummie1336151crummie_
crummier1435601crummier
crummiest1545561crummiest
rummies113212791_rummies
brumbies1436532brumbies
cammies134016482c_ammies
chammies172910162chammies
chummier1734512chummier
chummiest1834642chummiest
commies133718452c_ommies
crumbier1456362crumbier
crumbiest1536252crumbiest
crumbles14329682crumbles
crumminess1643692crumminess
crumples14348812crumples
cummins1358962c_ummins
dummies123012132_dummies
gremmies1355992gremmies
mummies103812842_mummies
rummier11309562_rummier
rummiest12299352_rummiest
tummies113012032_tummies
yummies14359532_yummies
armies85123693ar__mies
brulyies1343423brulyies
brulzies1933983brulzies
brumes106417073bru_m_es
calumnies1346043calumnies
cammie124615293c_ammie_
chammied18215973chammied
chuckies1937703chuckies
chummed17396443chumm_ed
chummily2042843chummily
chumminess1943113chumminess
chumming18366203chumming
clammier1435843clammier
clammiest1535743clammiest
clumpier1435583clumpier
clumpiest1535353clumpiest
clumsier1234733clumsier
clumsiest1335393clumsiest
commie124215523c_ommie_
commits133812383c_ommits
commixes2177353c_ommixes
counties10316283counties
crambes1339963cr_ambes
cramboes1436543cramboes
crammed143710123cramm_ed
crammer134010963cramm_er
crammers14369353crammers
cramming15339433cramming
crampier14288903crampier
crampiest15268623crampiest
crampits1436273crampits
crannies10313013crannies
crappies142911163crappies
crazies183413853cr_azies
creamier12319063creamier
creamiest13248933creamiest
creepies1239613creepies
cremains1238693cremains
cremates124216003cremates
cremes104517993cr_em_es
cries75438403cr___ies
crimes105521583cr_im_es
crimmer133310773crimm_er
crimmers14298543crimmers
crimpier14287323crimpier
crimpiest15237183crimpiest
crimples14308963crimples
cronies9622503cr_onies
croppies143111133croppies
crowdies1437553crowdies
cruces105117543cru__ces
crucifies1646123crucifies
cruddier1244153cruddier
cruddiest1334453cruddiest
crudes96218623cru__des
crudites1137763crudites
crudities1247743crudities
cruelties1144893cruelties
cruise84314043cru__ise
cruises93514443cru_ises
crumbed14378473cru_mbed
crumber13339643cru_mber
crumbers14338243crumbers
crumbing15267813crumbing
crumble133410403crumble_
crumbled15357443crumbled
crumblier1543873crumblier
crumbliest1643903crumbliest
crumbs12409233cru_m_bs
crumbums1642733crumbums
crummy15365893crumm__y
crumped144311223cru_mped
crumpet133711063cru_mpet
crumpets14335943crumpets
crumping15319903crumping
crumple13368363crumple_
crumpled15296873crumpled
crumplier1543783crumplier
crumpliest1644123crumpliest
crumps124514343cru_m_ps
crunches153711353crunches
crunodes1144973crunodes
crusades1146333crusades
cruses88127713cru__ses
crushes124215133cru_shes
crustier10259533crustier
crustiest112410053crustiest
crutches15359593crutches
cruxes154911563cru__xes
cubbies133312883c_ubbies
cuddies113313263c_uddies
cullies94419963c_ullies
cumbias13338963c_umbias
cumins103314933c_u_mins
cummer124414593c_umm_er
cummers133713483c_ummers
cummin1288783c_ummi_n
curacies12311763curacies
curies84934023c_u_ries
curries93723163c_urries
curtsies1038733curtsies
cuties84927363c_u_ties
cutties93118843c_utties
druggies11126223druggies
drumbles13277723drumbles
drumfires1542553drumfires
drumlier1134523drumlier
drumliest1235433drumliest
drumlins1144993drumlins
drummed13306323drumm_ed
drummer12407503drumm_er
drummers13316163drummers
drumming14265783drumming
dummied13346723_dummied
frumpier1534173frumpier
frumpiest1634543frumpiest
gimmies123010113_gimmies
grammes123611323gramm_es
gremmie1264383gremmie_
grumbles13288873grumbles
grumes94415553gru_m_es
grummer12338783grumm_er
grummest13286363grumm_est
grummet12298873grumm_et
grummets13275033grummets
grumphies1743653grumphies
grumpier1334803grumpier
grumpiest1435023grumpiest
gummier12349473_gummier
gummiest13269033_gummiest
gummites1346173_gummites
immies102412443__immies
jammies183611293_jammies
jemmies18318333_jemmies
jimmies18328783_jimmies
mammies104314763_mammies
mommies103912273_mommies
mummied11327103_mummied
plummier1434123plummier
plummiest1544973plummiest
pommies133712843_pommies
preemies12512193preemies
premies113823063pr_emies
ramies84630463_r_amies
rammier112811023_rammier
rammiest12299933_rammiest
roomies93017243_roomies
rubbies114114113_rubbies
rubies84420343_ru_bies
rugbies10339353_rugbies
rumbles114018393_rumbles
rummages1344933_rummages
rummer104715483_rumm_er
rummers113513653_rummers
rummest11279833_rumm_est
rumples113313133_rumples
scrummages1752053scrummages
scrummed1554313scrumm_ed
scrumming1654023scrumming
scummier1445083scummier
scummiest1535213scummiest
shammies15259693shammies
shimmies15287803shimmies
slummier1235473slummier
slummiest1335673slummiest
summits1137983_summits
tammies113814683_tammies
thrummier1641793thrummier
thrummiest1742093thrummiest
tommies113812983_tommies
trusties82712853trusties
whammies18265513whammies
yummier14306843_yummier
yummiest15256723_yummiest

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.436409841.7
2DLD Change Limit1461621987.62319173.8
3Display Results1981980.0802475.0
 (SQL Overall)1786911988.13921954.9
 
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.