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

144 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
crummie133615(None) 
crummier1435601crummier
crummies1437641crummies
cammie124615292c_ammie
chummier1734512chummier
commie124215522c_ommie
crumbier1456362crumbier
crumble133410402crumble
crummiest1545562crummiest
crummy15365892crumm_y
crumple13368362crumple
cummin1288782c_ummin
gremmie1264382gremmie
rummier11309562_rummier
rummies113212792_rummies
brulyie1242523brulyie
brulzie1842883brulzie
brumbies1436533brumbies
brume95817983bru_m_e
cammies134016483c_ammies
chammied18215973chammied
chammies172910163chammies
chummed17396443chummed
chummiest1834643chummiest
chummily2042843chummily
chumming18366203chumming
chummy18385893chumm_y
clammier1435843clammier
clumpier1435583clumpier
clumsier1234733clumsier
commies133718453c_ommies
commit124016703c_ommit
commix19407763c_ommix
couthie121810553couthie
crambe1239073cr_ambe
crammed143710123crammed
crammer134010963crammer
cramming15339433cramming
crampier14288903crampier
crampit1338863crampit
crappie13298983crappie
creamier12319063creamier
creepie1137483creepie
cremate113816183cremate
creme94319323cr_em_e
crime94822693cr_im_e
crimine112413473crimine
crimmer133310773crimmer
crimpier14287323crimpier
crimple13408693crimple
croppie13278793croppie
crowdie1335913crowdie
cruddier1244153cruddier
crude86018573cru__de
cruise84314043cru_ise
crumb114313593cru_m_b
crumbed14378473crumbed
crumber13339643crumber
crumbiest1536253crumbiest
crumbing15267813crumbing
crumbled15357443crumbled
crumbles14329683crumbles
crumblier1543873crumblier
crumbly16347523crumbly
crumbs12409233cru_mbs
crumbum1543743crumbum
crumby15408113cru_mby
crumminess1643693crumminess
crump115616423cru_m_p
crumped144311223crumped
crumpet133711063crumpet
crumping15319903crumping
crumpled15296873crumpled
crumples14348813crumples
crumplier1543783crumplier
crumply16336093crumply
crumps124514343cru_mps
crunode1034713crunode
crusade1036053crusade
cruse75726103cru__se
crustier10259533crustier
cuddie104011173c_uddie
cumbia12379893c_umbia
cumin94616973c_u_min
cummer124414593c_ummer
cummins1358963c_ummins
curie74533043c_u_rie
currie84317263c_urrie
cutie76925933c_u_tie
druggie10134083druggie
drumble12337893drumble
drumfire1442543drumfire
drumlier1134523drumlier
drumlike1543793drumlike
drumlin1044423drumlin
drummed13306323drummed
drummer12407503drummer
drumming14265783drumming
dummied13346723_dummied
dummies123012133_dummies
frumpier1534173frumpier
gimmie11298183_gimmie
gramme114210333gramm_e
gremmies1355993gremmies
grumble12349233grumble
grume86218163gru_m_e
grummer12338783grummer
grummet12298873grummet
grumose1035723grumose
grumphie1642763grumphie
grumpier1334803grumpier
grushie1135813grushie
gummier12349473_gummier
gummite1236133_gummite
jimmie17376473_jimmie
mammie94313783_mammie
mummied11327103_mummied
mummies103812843_mummies
plummier1434123plummier
pommie123710503_pommie
preemie11310563preemie
premie103617993pr_emie
primsie1137543primsie
ramie75027823_r_amie
rammier112811023_rammier
roomie83013873_roomie
rumble103718813_rumble
rummage1234583_rummage
rummer104715483_rummer
rummiest12299353_rummiest
rummy124212413_rumm_y
rumple103913013_rumple
scrummage1641873scrummage
scrummed1554313scrummed
scrumming1654023scrumming
scummier1445083scummier
slummier1235473slummier
summae103911013_summae
summit10311543_summit
tammie104212693_tammie
thrummier1641793thrummier
tummies113012033_tummies
yummier14306843_yummier
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 Filter1786911340270.390458182.1
2DLD Change Limit1340271446.72019944.5
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.17324911.6
 
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.