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

175 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
crumpets1433594(None) 
crumpet133711061crumpet_
trumpets12315571trumpets
crampits1436272crampits
crimpers14318932crimpers
cruets85314952cru__ets
crumbers14338242crumbers
crumped144311222crumpe_d
crumples14348812crumples
crumps124514342crump__s
cruppers14317322cruppers
crusets93811042cru_sets
grummets13275032grummets
strumpets1362892strumpets
trumpet113810722trumpet_
armets84918353ar_m_ets
armlets94610063ar_mlets
armpits1157133ar_mpits
brumes106417073brum_e_s
brunets9419553bru_nets
bumpers133912053_bumpers
calumets1236283calum_ets
camlets114314623c_amlets
campers134220293c_ampers
carpets113915333c_arpets
cermets1139713cerm_ets
cerumens1235763cerum_ens
champers173311623champers
chompers17369593chompers
chumped17379493chumpe_d
chumps154313823chump__s
clampers143211893clampers
clumbers143910413clumbers
clumped143610663clumpe_d
clumpiest1535353clumpiest
clumps1215314643clump__s
coempts1335683coemp_ts
comets105823583c_om_ets
compels133210883c_ompels
compete134716553c_ompete
competes144117243c_ompetes
compts125216653c_omp_ts
coupes105022523cou_pe_s
couplets12389873couplets
crambes1339963crambe_s
crammers14369353crammers
cramped144712183crampe_d
crampiest15268623crampiest
crampit1338863crampit_
crampons1436643crampons
cramps125615563cramp__s
crapes104727693cr_ape_s
crappers144011023crappers
creepers12318633creepers
cremates124216003cremates
cremes104517993crem_e_s
crepes105419343cr_epe_s
cressets10309103cressets
crickets16418123crickets
crimes105521583crim_e_s
crimmers14298543crimmers
crimped143910763crimpe_d
crimper136510423crimpe_r
crimpiest15237183crimpiest
crimples14308963crimples
crimps124613453crimp__s
cripes105120873cr_ipe_s
crispens12286253crispens
crispers12309433crispers
crispest12177373crispest
crochets15359833crochets
crockets16339543crockets
croppers143311483croppers
croquets1955213croquets
croupes114613103croupe_s
crownets13407673crownets
cruces105117543cru_ce_s
crudes96218623cru_de_s
crudest104510333cru_dest
crudites1137763crudites
cruelest1059183cruelest
cruet74831843cru__et_
cruisers10438273cruisers
cruises93514443cruise_s
crullers1047303crullers
crumbed14378473crumbe_d
crumber13339643crumbe_r
crumbiest1536253crumbiest
crumbles14329683crumbles
crumbs12409233crum__bs
crumbums1642733crumbums
crummies1437643crummies
crummiest1545563crummiest
crump115616423crump___
crumping15319903crumping
crumple13368363crump_le
crumpled15296873crumpled
crumpliest1644123crumpliest
crumply16336093crump_ly
crupper13338563cruppe_r
cruses88127713cru_se_s
cruset84425093cru_set_
crushers134010093crushers
crushes124215133crushe_s
crusts84916543cru__sts
cruxes154911563cru_xe_s
crypts13397743cr_yp_ts
culets85518513c_u_lets
cullets94015613c_ullets
cumbers134515413c_umbers
cummers133713483c_ummers
cupels10310203c_u_pels
cuppers133712213c_uppers
curets84922343c_u_rets
curvets12399913c_urvets
cutlets94113653c_utlets
druggets11313913druggets
drumbeats1442323drumbeats
drummers13316163drummers
drupes94912653dru_pe_s
dumpers123412663_dumpers
erumpent1245453erumpent
erupts8348903eru_p_ts
frumpiest1634543frumpiest
frumps13479783frump__s
fumets114311813_fum_ets
grommets13234663grommets
grumes94415553grum_e_s
grummest13286363grummest
grummet12298873grummet_
grumped13337333grumpe_d
grumpiest1435023grumpiest
grumps114510573grump__s
humpers142713523_humpers
jumpers18399843_jumpers
limpets11329783_limpets
lumpens11298263_lumpens
lumpers113514483_lumpers
maumets11369693maum_ets
mumpers133311373_mumpers
plummets14304773plummets
plumpens14304953plumpens
plumpers14357293plumpers
plumpest14236353plumpest
prompts1337473promp_ts
pumpers133113673_pumpers
puppets10317013_puppets
ramets83517393_ram_ets
ramjets1635163_ramjets
remeets93712413_remeets
rompers113412243_rompers
rumens83611813_rum_ens
rummers113513653_rummers
rummest11279833_rummest
rumples113313133_rumples
rumpless12256543_rumpless
rumps95922293_rump__s
rumpus10458893_rump_us
runlets73310773_runlets
rupees8312573_ru_pees
russets738163_russets
scramjets2052063scramjets
scrimpers1554643scrimpers
strumpet1256033strumpet_
stumpers12318313stumpers
thumpers15365713thumpers
trampers123210393trampers
trippets12357423trippets
trompes114111623trompe_s
trumped12439713trumpe_d
trumpery1533613trumpery
trumpeted1443053trumpeted
trumpeter1343153trumpeter
trumpeters1442633trumpeters
trumps104611883trump__s

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621756.44022696.0
3Display Results1751750.0762302.6
 (SQL Overall)1786911756.93625762.8
 
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.