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

276 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
sacrum10391014(None) 
sacrums11388041sacrums
scrum95418191s_crum
arum66129032_a_rum
asarum84610912asarum
aurum7614962_aurum
labrum1057422labrum
larum74317972la_rum
sacbut10811942sacbut
sachem134012222sachem
sacque17107112sacque
sacra74516992sacr_a
sacral83414412sacral
sacred94917102sacred
sagum8512872sa_gum
sanctum1145282sanctum
scram910621612s_cram
scrim95419722s_crim
scrub94914202s_crub
scrums104614252s_crums
scum85924522s_c_um
serum75223472s_erum
strum75619442s_trum
vacuum1334832vacuum
acarus8312193_acarus
accrue1035823accrue
acetum1038463_acetum
acre67330773_acr_e
acred87126353_acred
acres76327763_acres
acrid86920103_acrid
aecium10410423aecium
alarum85411983alarum
album92312653_album
algum82711763_algum
alum65227613_a_lum
antrum8611313antrum
arcus76918863_arcus
arm58449623_a_r_m
arums75517833_a_rums
asarums9467613asarums
ascus75013583asc_us
ashram1139053ashram
asylum1144893asylum
atrium8411823_atrium
aurums849383_aurums
backup1646613backup
baculum1345703baculum
barium10313513barium
barm86739603ba_r_m
cactus104912233cactus
caecum1238183caecum
calcium1368593calcium
carom95025563ca_rom
carrom10513403carrom
cecum11611843cec_um
chum116318003__chum
cram85635493__cram
cru57129563__cru_
crud75219613__crud
crumb114313593__crumb
crump115616423__crump
crus65828483__crus
crux135415003__crux
cum76440163__c_um
cuprum1236743cuprum
dacron94310693dacron
dadgum1134583dadgum
datum8310633da_tum
decorum1246943decorum
dictum1136863dictum
drum76521593__drum
durum8513203_durum
eardrum10135423eardrum
ecru65819533_ecru_
ecrus75113863_ecrus
estrum81810513estrum
faceup1334893faceup
fanum10313443fa_num
farm95934533fa_r_m
ferrum1147453ferrum
forum108318763_forum
fulcrum1443483fulcrum
gaum75726423ga__um
grum75625083__grum
harem104924453ha_rem
harm95637793ha_r_m
iterum837903iterum
jorum145513743_jorum
kalium1239473kalium
labarum1166013labarum
labium10410243labium
labrums1175853labrums
lactam10310943lactam
larrup835713larrup
larums83610533la_rums
locum94812173loc_um
lyceum1343953lyceum
macrame1338713macrame
macro94718173macr_o
macron103615673macron
macros104017013macros
magnum1136733magnum
marram10313883marram
nacre75715363nacr_e
nacred95212493nacred
nacres85614453nacres
nairu5413813nairu_
nairus639143nairus
natrium948983natrium
oakum1177313oa_kum
pablum1237503pablum
quorum1736023quorum
racism103214193racism
radium93513293radium
rectum103411283rectum
rum56644643___rum
sabra75317853sabr_a
sabras85116363sabras
sabre74821503sabr_e
sabred95916533sabred
sabres85520863sabres
sac57452863sac___
sacbuts1166473sacbuts
saccule1136743saccule
sacculi1145043sacculi
sachems14348903sachems
sachet114725773sachet
sack105337313sac__k
sackbut1545943sackbut
sacked135525213sacked
sacker125124843sacker
sackful1645353sackful
sacks114228873sac_ks
sacques18106863sacques
sacrals93311793sacrals
sacrarium1344473sacrarium
sacring103115983sacring
sacrist9315423sacrist
sacs65739073sac__s
sadhu9459963sadhu_
sadhus10298463sadhus
sadism94113493sadism
safrol937283safrol
sagbut959753sagbut
sajou12311693sajou_
sajous13310583sajous
salaam8711013salaam
samarium1257283samarium
sambur10469503sambur
sanctums1244013sanctums
sannup836563sannup
santur6311273santur
sapour83812373sapour
saran53730303sa_ran
sarcasm1136693sarcasm
sarcoma1147403sarcoma
sarcous9312933sarcous
sard55344243sa_r_d
sards64736183sa_rds
saree55044663sa_ree
sarge65531133sa_rge
sargo65424413sa_rgo
sari45444043sa_r_i
sarin55239253sa_rin
saris54544953sa_ris
sark84938973sa_r_k
sarks96632463sa_rks
sarky125521783sa_rky
sarod65325873sa_rod
saros55238063sa_ros
satem76021453sa_tem
satrap86212553satrap
satsuma943873satsuma
sau36356573sa__u_
saul45836523sa__ul
saurel6511983saurel
saury84317223saur_y
savour94110703savour
scam85932353s_c_am
scar66434203scar__
scarab10310063scarab
scarce104013633scarce
scare75334463scar_e
scared95227293scared
scarer84524603scarer
scares85033003scares
scarey115016983scarey
scarf105427143scar_f
scarfs114714683scarfs
scarp95724103scar_p
scarph13429603scarph
scarps104718603scarps
scarry116311183scarry
scars75433533scar_s
scart76139773scar_t
scarts85321493scarts
scary105222593scar_y
scaup95515993s_caup
scaur75814903s_caur
scaurs85512053scaurs
schul102510413s_chul
scour75315533s_cour
scout75031453s_cout
scrag85916173s_crag
scrams105216623s_crams
scrap97120403s_crap
scream104814243s_cream
scree720031703s_cree
screw109318533s_crew
scrimp125110583s_crimp
scrims104615933s_crims
scrip96619193s_crip
scrod85115063s_crod
scrotum1145113s_crotum
scrubs104210313s_crubs
scruff1437963s_cruff
scry96017763s_cr_y
scud76221283s_c_ud
scums95017423s_c_ums
scup84822383s_c_up
scurf104719323s_curf
scut65835543s_c_ut
scutum1036363scutum
sebum93814553s_ebum
secret8325063secret
secure8513533secure
sedum84115573s_edum
sensum849353sensum
septum1037993septum
serums83916303s_erums
shrub104814893s_hrub
shrug94512513s_hrug
siglum936563siglum
sirup74014913s_irup
sistrum946553sistrum
slum65430513s__lum
smarm95517603smar_m
sodium92111443sodium
solum74717603s_olum
sorus54527583s_orus
spectrum1444063spectrum
sperm93216013sper_m
spirem104214163spirem
sprue74717633s_prue
sprug85313893s_prug
sputum1035933sputum
stackup1533743stackup
stadium1038073stadium
stannum944643stannum
sternum947733sternum
stickum1534823stickum
storm76520383stor_m
struma84313273s_truma
strums84716453s_trums
strut56030733s_trut
stum65526013s__tum
subgum1136133subgum
succumb1543283succumb
sucre75019103sucr_e
sucres84218893sucres
sum56346013s___um
swarm106218833swar_m
swum96416823s__wum
syrup103010963s_yrup
talcum1036953talcum
tantrum946683tantrum
tectum10328603tectum
thrum104713633_thrum
vacua10510463vac_ua
vacuums1443403vacuums
vagrom1235943vagrom
varus85921183va_rus
walrus956433walrus
wampum15406053wampum
warm95935673wa_r_m

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162766.51617298.3
3Display Results2762760.0932967.7
 (SQL Overall)1786912766.74926476.7
 
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.