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

201 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
crampon133694(None) 
crampons1436641crampons
crampoon1444541crampoon
camion103917192c_amion
campion133011412c_ampion
campo115219762c_ampo_
campong14318122c_ampong
campos125217952c_ampos
capon95221872c_a_pon
champion17276352champion
crambo1238042crambo_
crambos1336782crambos
cramp115120692cramp__
cramped144712182cramped
cramping153411852cramping
crampit1338862crampit
crampoons1544062crampoons
cramps125615562cramp_s
crampy154710992cramp_y
craton84517192cra_ton
crayon114110002cra_yon
crepon1039942cr_epon
crimson1135642crimson
rampion11298582_rampion
ramson8310462_ramson
tampon102911232_tampon
acromion1246063acromion
bradoon1037353bradoon
cajon144513903c_a_jon
cameo95924993c_ameo_
cameos105818003c_ameos
camions113916133c_amions
camo85731753c_am_o_
camos95927613c_am_os
camp106336453c_amp__
camped134720233c_amped
camper124722213c_amper
camphol1645793c_amphol
camphor1636133c_amphor
campi116217783c_amp_i
camping143118973c_amping
campions143511293c_ampions
campongs15356123c_ampongs
campout13412853c_ampout
camps116330263c_amp_s
campus125213923c_ampus
campy145116183c_amp_y
cannon84514443c_annon
canon74725303c_a_non
canton85722993c_anton
canyon114512033c_anyon
capo85829213c_a_po_
capons104119503c_a_pons
capos94826073c_a_pos
carbon104919043c_arbon
cardamon1345553cardam_on
cardon94120853c_ardon
cardoon104813813cardoon
carman103920743carm_an
carmen104019343carm_en
carrion9312673carrion
carryon1237033carryon
carton84522663c_arton
cartoon94114463cartoon
cation83925503c_ation
chamfron1844493chamfron
champ145017963champ__
champac1834953champac
champak2034493champak
champed174111483champed
champer163813413champer
champing183610933champing
champions18875783champions
champs154915683champ_s
champy18509613champ_y
chanson1238043chanson
chapman1637893chapman
chapmen1637283chapmen
charpoy1735713charpoy
clamor1049453clam_or
clamp115517653clamp__
clampdown1951843clampdown
clamped144012043clamped
clamper134012993clamper
clamping154011153clamping
clamps124515083clamp_s
clarion9311663clarion
classon937693classon
claxon1536583cla_xon
claypan1434313claypan
common12310803c_ommon
compo115318573c_ompo_
compone136517193c_ompone
compony1613011913c_ompony
compos124818803c_ompos
coupon102810993c_oupon
crackpot1843833crackpot
cram85635493cram___
crambe1239073cram_be
crambes1339963crambes
cramboes1436543cramboes
crammed143710123crammed
crammer134010963crammer
cramming15339433cramming
crampier14288903crampier
crampits1436273crampits
crams96229153cram__s
crankpin16103753crankpin
crannog1044243crannog
crap85731843cra_p__
crape96128443cra_p_e
craped116120523cra_ped
crapes104727693cra_pes
craping124018713cra_ping
crapola1136913cra_pola
crapped143912623crapped
crapper133913193crapper
crappie13298983crappie
crapping153911453crapping
crappy15446803cra_ppy
craps95328643cra_p_s
cratons94316033cra_tons
craven114113933cra_ven
crayons12439233cra_yons
creation102816513creation
crepons1139323cr_epons
crimp115615803crimp__
crimped143910763crimped
crimper136510423crimper
crimping15299783crimping
crimple13408693crimple
crimps124613453crimp_s
crimpy15489393crimp_y
crimsons1245633crimsons
crispen11348203crispen
croon75522783cr__oon
croton84415453cr_oton
crouton947133crouton
crumhorn1542893crumhorn
crump115616423crump__
crumped144311223crumped
crumpet133711063crumpet
crumping15319903crumping
crumple13368363crumple
crumply16336093crumply
crumps124514343crump_s
dampen114310593_dampen
damson938063_damson
dragon838843dra_gon
dragoon935283dragoon
dromon939363drom_on
erasion7311963erasion
gammon1138903_gammon
gramp106218323gramp__
grampa115010173gramp_a
grampas12399253grampas
gramps114114273gramp_s
grampus12356313grampus
kampong16294933_kampong
lampion11278303_lampion
lampoon11267193_lampoon
mammon939643_mammon
oration71617713oration
pompon1238943_pompon
psammon1342543psammon
racon75422143_ra_con
racoon83814473_racoon
radon64620503_ra_don
ramen75625193_ram_en
ramona8412413_ram_ona
ramp85934003_ramp__
rampant11312173_rampant
ramped114617903_ramped
ramping123316873_ramping
rampions12248023_rampions
rampole1139693_rampole
ramps96224633_ramp_s
ramrod936833_ramrod
ramsons939563_ramsons
rappen103512713_rappen
ration64226013_ration
ratoon64417373_ratoon
ratton64116123_ratton
rayon83815703_ra_yon
sampan102511893_sampan
shampoo1435373shampoo
tampan102512323_tampan
tampion11298663_tampion
tampons112711563_tampons
tarpon82812803_tarpon
tramp96319773tramp__
tramped124312433tramped
tramper113812163tramper
tramping132711273tramping
trample11299703trample
tramps105114453tramp_s
trampy13499253tramp_y
trapan82412973tra_pan
weapon11288113wea_pon
yapon104613583_ya_pon
yaupon11345493_yaupon

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.436409841.7
2DLD Change Limit1340272016.12621878.4
3Display Results2012010.0762644.7
 (SQL Overall)1786912016.63826919.4
 
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.