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

275 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
crumpet13371106(None) 
crumped144311221crumped
crumpets14335941crumpets
trumpet113810721trumpet
chumped17379492chumped
clumped143610662clumped
cramped144712182cramped
crampit1338862crampit
crimped143910762crimped
crimper136510422crimper
cruet74831842cru__et
crumbed14378472crumbed
crumber13339642crumber
crump115616422crump__
crumple13368362crumple
crumpled15296872crumpled
crumples14348812crumples
crumply16336092crumply
crumps124514342crump_s
crupper13338562crupper
cruset84425092cru_set
erumpent1245452erumpent
grummet12298872grummet
grumped13337332grumped
strumpet1256032strumpet
trumped12439712trumped
trumpets12315572trumpets
armet76739453ar_m_et
armlet84118193ar_mlet
armpit10811093ar_mpit
aruspex1642543aruspex
brume95817983brum_e_
brumes106417073brum_es
brunet84419293bru_net
bumped134414003_bumped
bumper123714343_bumper
calumet11313293calum_et
camlet104426583c_amlet
camped134720233c_amped
camper124722213c_amper
carpet104530093c_arpet
cermet10321153cerm_et
cerumen1147763cerum_en
champed174111473champed
champer163813403champer
chomped17329773chomped
chomper163810073chomper
chummed17396443chummed
chump145315443chump__
chumps154313823chump_s
clamped144012043clamped
clamper134012993clamper
clomped14398973clomped
clumber134011443clumber
clump115517453clump__
clumpier1435583clumpier
clumpiest1535343clumpiest
clumps1215314643clump_s
clumpy15409573clump_y
coempt12311033coemp_t
comet95946073c_om_et
comped135919873c_omped
compel124412893c_ompel
compete134716553c_ompete
compt116328223c_omp_t
coupe96023483cou_pe_
couped115019313cou_ped
coupes105022523cou_pes
couplet114717943couplet
crambe1239073crambe_
crambes1339953crambes
crammed143710123crammed
crammer134010963crammer
cramp115120693cramp__
crampier14288903crampier
crampiest15268613crampiest
crampits1436273crampits
crampon1336943crampon
cramps125615563cramp_s
crampy154710993cramp_y
crape96128443cr_ape_
craped116120523cr_aped
crapes104727693cr_apes
crapped143912623crapped
crapper133913193crapper
creeped12329713creeped
creeper11339973creeper
cremate113816183cremate
creme94319323crem_e_
cremes104517993crem_es
crepe95520723cr_epe_
creped114115703cr_eped
crepes105419343cr_epes
crepey135110933cr_epey
crept95125893cr_ep_t
cresset93319943cresset
cricket154716953cricket
crime94822693crim_e_
crimes105521583crim_es
crimmer133310773crimmer
crimp115615803crimp__
crimpers14318933crimpers
crimpier14287323crimpier
crimpiest15237183crimpiest
crimple13408693crimple
crimpled15366933crimpled
crimples14308963crimples
crimps124613453crimp_s
crimpy15489393crimp_y
cripe95521143cr_ipe_
cripes105120873cr_ipes
crisped124010103crisped
crispen11348203crispen
crisper113511053crisper
crispest12177373crispest
crochet143616663crochet
crocket154615673crocket
cropped143812063cropped
cropper133312963cropper
croquet1859683croquet
croupe105114433croupe_
croupes114613103croupes
crownet123714113crownet
cruces105117543cru_ces
crudded1235733crudded
crude86018573cru_de_
cruder95612383cru_der
crudes96218623cru_des
crudest104510333crudest
cruel74815903cru__el
crueler939023crueler
cruelest1059183cruelest
cruets85314953cru__ets
cruise84314043cruise_
cruised103710213cruised
cruiser93410433cruiser
cruises93514443cruises
cruller968753cruller
crumb114313593crum__b
crumbers14338223crumbers
crumbier1456363crumbier
crumbiest1536253crumbiest
crumble133410403crumble
crumbled15357443crumbled
crumbles14329683crumbles
crumbly16347523crumbly
crumbs12409233crum_bs
crumbum1543743crumbum
crumby15408113crum_by
crummie1336153crummie
crummier1435603crummier
crummies1437643crummies
crummiest1545563crummiest
crummy15365893crum_my
crumping15319903crumping
crumplier1543783crumplier
crumpliest1644113crumpliest
cruppers14317313cruppers
cruse75726103cru_se_
cruses88127713cru_ses
crusets93811043cru_sets
crushed134111963crushed
crusher124412323crusher
crushes124215133crushes
crust75827663cru__st
crusted103712753crusted
cruxes154911563cru_xes
crypt123715233cr_yp_t
culet76040343c_u_let
cullet84727313c_ullet
cumber124016703c_umber
cummer124414593c_ummer
cupel9514303c_u_pel
cupped134413983c_upped
cupper124313863c_upper
curet75447643c_u_ret
curvet114720243c_urvet
cusped114312043c_usped
cutlet84924363c_utlet
drugget10337613drugget
drumbeat1343973drumbeat
drummed13306323drummed
drummer12407503drummer
drupe85012993dru_pe_
drupes94912653dru_pes
dumped123814493_dumped
dumper114615213_dumper
erupt74220063eru_p_t
flumped15377713flumped
frump126912563frump__
frumpier1534173frumpier
frumpiest1634543frumpiest
frumps13479783frump_s
frumpy16466883frump_y
fumet105630223_fum_et
grommet12268453grommet
grume86218163grum_e_
grumes94415553grum_es
grummer12338783grummer
grummest13286363grummest
grummets13275033grummets
grump105115313grump__
grumphy18443623grumphy
grumpier1334803grumpier
grumpiest1435023grumpiest
grumps114510573grump_s
grumpy14498153grump_y
humped144015243_humped
humper134115883_humper
jumped183511553_jumped
jumper173612373_jumper
limpet103518633_limpet
lumped114216963_lumped
lumpen104010663_lumpen
lumper103816653_lumper
maumet103518883maum_et
mumped133813163_mumped
mumper123513523_mumper
plummet13278353plummet
plumped14318643plumped
plumpen13276403plumpen
plumper13318773plumper
plumpest14236353plumpest
premeet11615153premeet
primped14479153primped
prompt12313013promp_t
pumped133915563_pumped
pumper124415553_pumper
puppet93514593_puppet
ramet75743143_ram_et
ramjet15311543_ramjet
ramped114617903_ramped
remeet86325473_remeet
remet74843723_rem_et
romped114513653_romped
romper104213683_romper
roupet84218343_roupet
rumen74419503_rum_en
rummer104715483_rummer
rummest11279833_rummest
rump86729083_rump__
rumple103913013_rumple
rumpled123810013_rumpled
rumples113313133_rumples
rumply13348573_rumply
rumps95922293_rump_s
rumpus10458893_rumpus
runlet63821413_runlet
rupee7321283_ru_pee
russet6319433_russet
scramjet1945033scramjet
scrimped1555313scrimped
scrimper1455753scrimper
scrimpit1444183scrimpit
scrummed1554313scrummed
slumped123710153slumped
strumpets1362893strumpets
stumped124210153stumped
stumper113610093stumper
thumped15387413thumped
thumper14356953thumper
tramped124312433tramped
tramper113812153tramper
trippet113714113trippet
trompe105611263trompe_
tromped124210293tromped
trompes114111623trompes
trump95615123trump__
trumpery1533613trumpery
trumpeted1443053trumpeted
trumpeter1343153trumpeter
trumps104611883trump_s
tumped114216233_tumped
umped104717273__umped
whumped18335633whumped

Search took 7 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.1561145455.1
2DLD Change Limit1340272756.44020811.6
3Display Results2752750.1062594.3
 (SQL Overall)1786912756.70226662.3
 
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.