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

174 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
crampons143664(None) 
crampon1336941crampon_
crampoons1544061crampoons
camions113916132c_amions
campions143511292c_ampions
campong14318122c_ampong
campongs15356122c_ampongs
campos125217952c_ampo_s
capons104119502c_a_pons
champions18875782champions
cramboes1436542cramboes
crambos1336782crambo_s
cramping153411852cramping
crampits1436272crampits
crampoon1444542crampoon
cramps125615562cramp__s
cratons94316032cra_tons
crayons12439232cra_yons
crepons1139322cr_epons
crimsons1245632crimsons
rampions12248022_rampions
ramsons939562_ramsons
tampons112711562_tampons
bradoons1136763bradoons
cameos105818003c_ameo_s
camion103917193c_amion_
camos95927613c_am_o_s
campers134220293c_ampers
camphols1746243c_amphols
camphors1737053c_amphors
camping143118973c_amping
campings154010203c_ampings
campion133011413c_ampion_
campo115219763c_ampo__
campout13412853c_ampout
campouts1436823c_ampouts
camps116330263c_amp__s
campus125213923c_amp_us
cannons94412883c_annons
canons85522063c_a_nons
cantons95221203c_antons
canyons124511593c_anyons
capon95221873c_a_pon_
capos94826073c_a_po_s
carbons115418943c_arbons
cardamons1445203cardam_ons
cardons104519943c_ardons
cardoons113411943cardoons
carrions10312453carrions
carryons1337103carryons
cartons94122473c_artons
cartoons104012803cartoons
cations94524143c_ations
chamfrons1944383chamfrons
chamois143512193cham_ois
champacs1934633champacs
champaks2134103champaks
champers173311623champers
champing183610933champing
champion17276353champion_
champs154915683champ__s
chansons1337473chansons
charpoys1834533charpoys
clamors11710093clam_ors
clampdowns2051673clampdowns
clampers143211893clampers
clamping154011153clamping
clamps124515083clamp__s
clarions10310493clarions
classons1037703classons
claxons1635803cla_xons
claypans1543873claypans
commons13311043c_ommons
compone136517193c_ompone
compony1613011913c_ompony
compos124818803c_ompo_s
coupons112710563c_oupons
crackpots1942833crackpots
crambes1339963cram_bes
crambo1238043crambo__
crammers14369353crammers
cramming15339433cramming
cramoisy1543703cram_oisy
cramp115120693cramp___
cramped144712183cramp_ed
crampfish2142593crampfish
crampier14288903crampier
crampiest15268623crampiest
crampit1338863cramp_it
crampy154710993cramp__y
crams96229153cram___s
crankous1435973crankous
crankpins17133763crankpins
crannogs1143783crannogs
crapes104727693cra_p_es
craping124018713cra_ping
crapola1136913cra_pola
crapolas1247403cra_polas
crappers144011023crappers
crappies142911163crappies
crapping153911453crapping
craps95328643cra_p__s
craton84517193cra_ton_
cravens124010123cra_vens
crayon114110003cra_yon_
creations112614543creations
cremains1238693cremains
crepon1039943cr_epon_
crimpers14318933crimpers
crimping15299783crimping
crimples14308963crimples
crimps124613453crimp__s
crimson1135643crimson_
crispens12286253crispens
croons85418423cr__oons
crotons93714373cr_otons
croupous1245923croupous
croutons1036753croutons
crumhorns1642343crumhorns
crumpets14335943crumpets
crumping15319903crumping
crumples14348813crumples
crumps124514343crump__s
dampens12348563_dampens
damsons1038013_damsons
dragons938383dra_gons
dragoons1045013dragoons
dromons1038193drom_ons
erasions8310983erasions
gammons1237973_gammons
grampas12399253gramp_as
gramps114114273gramp__s
grampus12356313gramp_us
kampong16294933_kampong
kampongs17293033_kampongs
lampions12277973_lampions
lampoons12266873_lampoons
mammons1048513_mammons
orations81515803orations
pompons1338553_pompons
psammons1442783psammons
racons84319343_ra_cons
racoons93912433_racoons
radons74118533_ra_dons
ramona8412413_ram_ona
ramonas9311093_ram_onas
ramous8417113_ram_ous
rampant11312173_rampant
ramping123316873_ramping
rampion11298583_rampion_
rampole1139693_rampole
rampoles1238893_rampoles
ramps96224633_ramp__s
ramrods1036583_ramrods
ramson8310463_ramson_
rations74123433_rations
ratoons73815473_ratoons
rattons73815323_rattons
rayons94113343_ra_yons
sampans112411003_sampans
shampoos1544603shampoos
tampans113310983_tampans
tampions12358123_tampions
tampon102911233_tampon_
tarpons92612213_tarpons
trampers123210393trampers
tramping132711273tramping
tramples122610203tramples
tramps105114453tramp__s
trapans92812463tra_pans
trappous1246023trappous
weapons12278603wea_pons
yapons114411773_ya_pons
yaupons12345683_yaupons

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621746.53322372.9
3Display Results1741740.0602900.0
 (SQL Overall)1786911747.01325480.0
 
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.